Skip to main content
Solved

Why are my joined attributes not being written?


I'm just trying to do a simple join of LSOA areas and an excel with some ONS data, joining based on the field 'LSOA_code'. The join mode is set to inner and appears to join based on the visual preview below from the joined output port but when I write to gdb, the fields I want to add from the excel don't appear to be exposed in the writer.

 

workbenchgdb writer 

Best answer by ebygomm

The issue is with the attribute names, it looks like names coming from the excel data are not allowable in the gdb, so you will need to rename.

View original
Did this help you find an answer to your question?

4 replies

ebygomm
Influencer
Forum|alt.badge.img+33
  • Influencer
  • Best Answer
  • November 23, 2021

The issue is with the attribute names, it looks like names coming from the excel data are not allowable in the gdb, so you will need to rename.


ebygomm wrote:

The issue is with the attribute names, it looks like names coming from the excel data are not allowable in the gdb, so you will need to rename.

Ah is it just because of the spaces?


ebygomm
Influencer
Forum|alt.badge.img+33
  • Influencer
  • November 23, 2021
hannah.wheldon wrote:

Ah is it just because of the spaces?

Yes, spaces and the % sign


hannah.wheldon wrote:

Ah is it just because of the spaces?

Thank you! So simple and obvious now you point it out 🙊


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings