Skip to main content
Solved

How to find attributes in GIS that is not in my excel file?


timnil00
Contributor
Forum|alt.badge.img+5

Hello!

I have a GIS layer with a field named “yttyp” wich contains all various of attributes since its a text type.

I also have an Excel-file with allowed attributes.

 

How can i check if there is unallowed attributes in my GIS layer that is not in my Excel-file, and list them in a new excel-file.

 

I have tried change detector, listsearcher, featureMerger but i dont get it to work.

Best answer by lambertus

@timnil00 the right approach for this is to compare both columns with the attribute names like you did already. To do so its important that the attribute names which are present in both the GIS layer and the Excel file have the same name. In that way they are connected within a FeatureJoiner.

Steps:

Use a FeatureJoiner - Use GIS layer and Excel as the Left and Right Input - Choose the names of your columns which contain the attribute names. The attribute names that do not join are the ones you are searching for.

 

 

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

2 replies

lambertus
Enthusiast
Forum|alt.badge.img+12
  • Enthusiast
  • Best Answer
  • July 2, 2024

@timnil00 the right approach for this is to compare both columns with the attribute names like you did already. To do so its important that the attribute names which are present in both the GIS layer and the Excel file have the same name. In that way they are connected within a FeatureJoiner.

Steps:

Use a FeatureJoiner - Use GIS layer and Excel as the Left and Right Input - Choose the names of your columns which contain the attribute names. The attribute names that do not join are the ones you are searching for.

 

 


timnil00
Contributor
Forum|alt.badge.img+5
  • Author
  • Contributor
  • July 2, 2024

@lambertus Thank you so much for this clear explanation, it worked perfect :)


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