Empty Output When Transforming Excel-to-Table

Question

Hello everyone,

I am having an issue when transforming an excel file into a table and then join the latter to a Shapefile.

After performing the join of the transformed excel file into a table, I try to change the symbology but when selecting the field, it looks like it doesn't have any class so I am not able to, for instance, assign different colors to the classes.

What can be the root cause of it? An issue with the transformation or the join?

The field has a list of numbers such as "1.90" "1.00" "23.43" and so on.

Thank you!

sarab · Answer

@DavidPike @JayantaPoddar thanks for the suggestions, I tried to create another layer and re-join and it worked. I am not sure why with the first layer within the same project was not working, but now it seems it does 🙃

JayantaPoddar · Answer

Did the final table (after Join) look fine? Then Join would have taken place successfully, else there is an issue with Join.

A couple of screenshots showing the workflow and the issue may help us understand the concern better.

What is the field with the list ("1.90" "1.00" "23.43" and so on) used for?

The FieldType looks like Text. In case you want to use it for symbolizing quantitatively, create a new field with Float or Double FieldType, and use Field Calculator to get the same values from the text field.

For Python Parser, expression: !textfieldname!

Edit:

I think David already suggested what I had in my mind.

@sarab Could you share the the excel, so that we can have a look at it?

DavidPike · Answer

oh, is the table still joined? If you can, try exporting the joined table to a new feature class/shapefile as it will probably have to run statistics for the classes - or do you need the linked join still?