Hi,
I have a lot of DXF files and want only specific layers from this data. Additionally I have an excel file with all layers I want to filter in one column.How can I use the excel file as kind of a filter for the DXF files? The names of the DXF layer are pretty long and it would take to much time to write them all in a testfilter.
Thanks and best regards
Best answer by erik_jan
Similar to @markatsafe, you could also read both Excel and DXF files and use the FeatureJoiner transformer (DXF as Left, Excel as Right).
The Joined output port will output all DXF data from layers that are in the Excel sheet.
Hope this helps.
@joe_gerner You can use a DatabaseJoiner. Expose the fme_feature_type attribute on your AutoCad reader feature type. Then do a join on your Excel table. Test the results for the _matched_records attribute that the DatabaseJoiner adds.
Alternative, just cut & paste the list of AutoCAD layers into the Feature Types to Read parameter on the AutoCAD reader
+26Similar to @markatsafe, you could also read both Excel and DXF files and use the FeatureJoiner transformer (DXF as Left, Excel as Right).
The Joined output port will output all DXF data from layers that are in the Excel sheet.
Hope this helps.
