nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Table join unsuccessful / Multiple symbology - fields missing

TamraSteens

Hi there,

I have a couple of questions - firstly when I try & do a table join, joining .xslx to an attribute table, the fields join but everything is Null.

Secondly, when I try to vary symbology by attribute a limited number of fields are available.

Any hints on either of these subjects would be much appreciated!

Thanks, Tamra

Finde mehr Beiträge mit dem Tag

Accepted answers

TamraSteens

Hi Dan,

Sorry to not reply, I got caught up in other things. Both problems have been solved - I used Add Field to have multiple symbology, and the tables weren't joining because the data in the fields I was trying to join didn't match. Seems simple now, but I guess that's all part of learning new things. Thanks heaps for your help.

Kind regards

Tamra

danretired

Excel To Table (Conversion)—ArcGIS Pro | Documentation would be my recommendation, then use that for the join.

A lot can go wrong when using excel.

As for symbology, this?

Attribute-driven symbology—ArcGIS Pro | Documentation

there are limitations

Work with Microsoft Excel files in ArcGIS Pro—ArcGIS Pro | Documentation

make sure your fields are formatted explictly and I advise not having any blank cells in any column. If you need a null/nodata value, provide one rather than leaving cells empty. If you have numeric fields explicitly format them as such in excel.

All comments

danretired

let us know if it works

TamraSteens

Awesome, I vaguely remember coming across this now that you mention floats. Thanks for your help

danretired

If there are no matches OR the data are floats/doubles, then that isn't unexpected. Joins work with integer to integer or text to text. Float to float has numeric expression issues

A couple of examples of the records that you are trying to join would be useful

curtvprice

Dan's suggestion of copying the table from .xlsx into the geodatabase before doing the join is good advice, joins to excel sometimes just don't work as well.

TamraSteens

Okay, thanks. I can't see where I have gone wrong, but will have another look.

Cheers

curtvprice

If you do a join and your tables go empty this is often because the table or field names are not friendly to SQL queries (Field1, Field2 are friendly, "My field1" "fielda/b" "123" are unfriendly). The formatting is to force data type on the fields if they do read in OK so they will come in as numeric instead of text. This is all discussed in the help documents referenced up thread.

Dan and I both mentioned formatting because of your second question of your original post.

TamraSteens

Thanks @DanPatterson , that's super helpful.

Thanks @curtvprice. Do you mean make sure ALL Excel data is formatted as numeric? I don't think I follow. The problem is none of the info showed up, not just the blank cells. Do you have any idea why this would have happened?

Thanks,

Tamra

curtvprice

Dan has lots of good advice there. Some of things that go wrong that are easily fixed are:

1) Excel file, worksheet, and field names must start with a letter, no spaces, no special chars except "_". ArcGIS can overlook this until you try a join and then the SQL engines break on the bad names.

2) Do format table data as numeric. The "missing" fields are probably coming as text because there are lots of blanks or strings in the excel file.

danretired

Excel To Table (Conversion)—ArcGIS Pro | Documentation would be my recommendation, then use that for the join.

A lot can go wrong when using excel.

As for symbology, this?

Attribute-driven symbology—ArcGIS Pro | Documentation

there are limitations

Work with Microsoft Excel files in ArcGIS Pro—ArcGIS Pro | Documentation

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.