Question

Can you control attribute filter using an excel list of attributes

  • 3 January 2020
  • 5 replies
  • 8 views
C
Badge

I have a csv file with 55 attributes for each feature, I'd like to join only relevant attributes to various shapefiles (using FeatureJoiner). For example my Farm shapefile may need only 10 of those 55 attributes, my Buildings shapefile could require 20 attributes from the csv. For each shapefile I have an excel list of required attributes. How can I read in the main csv and filter it based on the xls - so only the attributes on the xls are passed to the FeatureJoiner?

Have tried Attribute Filter, importing the xls but I can't see how to filter on this?

Any suggestions?

Thanks

Chris

 

5 replies

erik_jan
Rank
Userlevel 2
Badge +12

Would it also be an option to join all attributes and define the writer to use only the attributes that you need?

This is much easier to accomplish.

C
Badge

Hi erik_jan

Thanks for responding. Yes I can do that but I still have to manually select the required attributes within the writer. I'm trying to find something that can do that from the xls.

erik_jan
Rank
Userlevel 2
Badge +12

The SchemaMapper transformer has options to filter attributes based on a spreadsheet.

M
Badge +2

@cbrown You can use the schema feature that is created by the FeatureReader. Modify the list of attributes and then use the EsriShape writer in dynamic mode to create the shape files with the correct attributes. Something like:

I've attached the example workspace (2019.1): dynamicschema.fmwt

takashi
Rank
Userlevel 2
Badge +17

Since you already have the Excel table that defines attribute sets for each destination Shapefile datasets, I think you can enhance the table to use it as a lookup table to configure destination schema at run-time.

See here to learn more: Destination Schema is Derived from a Lookup Table

Reply


Community Stats

28,635
Posts
109,185
Replies
36,514
Members
Terms & ConditionsCookie settings
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.