Skip to main content
Solved

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

  • July 2, 2024
  • 2 replies
  • 55 views
timnil00
Contributor
Forum|alt.badge.img+6

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.

 

 

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.

2 replies

lambertus
Enthusiast
Forum|alt.badge.img+24
  • lambertusEnthusiast
  • 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+6
  • timnil00Contributor
  • Author
  • Contributor
  • July 2, 2024

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

lambertus

Community Stats

32,154
Posts
122,044
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.