Skip to main content
Solved

Why are my joined attributes not being written?

  • November 23, 2021
  • 4 replies
  • 9 views

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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

4 replies

ebygomm
Influencer
Forum|alt.badge.img+44
  • Influencer
  • 3422 replies
  • 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.


  • Author
  • 2 replies
  • 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.

Ah is it just because of the spaces?


ebygomm
Influencer
Forum|alt.badge.img+44
  • Influencer
  • 3422 replies
  • November 23, 2021

Ah is it just because of the spaces?

Yes, spaces and the % sign


  • Author
  • 2 replies
  • November 23, 2021

Ah is it just because of the spaces?

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