Skip to main content
Solved

AttributeFilter - possible attribute values - multiline

  • December 18, 2015
  • 5 replies
  • 60 views
A
Forum|alt.badge.img

I have to filter out data based on a lot of values. Lets say, 50 values out of a 1000. I am using AttributeFilter for that and it works great, BUT it takes a lot of time and is extremely inconvenient to enter every attribute value and connect it. I could manage to copy many values from Excel, and when pasting them in I get something called 'multi-line' and I could connect only that one. It would be great if that would work. However, it doesnt. Plus judging from documentation Im not sure its designed for this purpose, but its not clear.

Can somebody advice me something, please. Or explain the purpose of multi-line within AttributeFilter. Thanks a lot! P.S. I work with CityGML data.

Best answer by erik_jan

You can read the Excel file and use the FeatureMerger to merge both you data source and the Excel file. All merged features will have the requested value for the join attribute. This will allow you to add values to the process without editing the workspace.

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.

5 replies

erik_jan
Contributor
Forum|alt.badge.img+23
  • erik_janContributor
  • Contributor
  • Best Answer
  • December 18, 2015

You can read the Excel file and use the FeatureMerger to merge both you data source and the Excel file. All merged features will have the requested value for the join attribute. This will allow you to add values to the process without editing the workspace.

erik_jan
Contributor
Forum|alt.badge.img+23
  • erik_janContributor
  • Contributor
  • December 18, 2015

If you want values in the AttributeFilter you can use the import button on the settings, rather than copying the values from the Excel spreadsheet. This will make a hardcopy of the values into the transformer settings.

mark2atsafe
Safer
Forum|alt.badge.img+59
  • mark2atsafeSafer
  • Safer
  • December 18, 2015

If it's mostly a pain to connect all the ports, use View > Windows > Feature Type Connections. That opens a window in which you can select all the output ports at one time, pick a single port to connect them to, then click the connect button

FME Evangelist to the Rich and Famous!!
A
Forum|alt.badge.img
  • anete
  • Author
  • December 21, 2015

Thanks a lot! Both would work indeed, but I ended up using FeatureMerger as then I can avoid AttributeFilter all together and make a workflow easier.

Ill remember about Feature Type Connections too tho! Thanks!

fmelizard
Safer
Forum|alt.badge.img+21
  • fmelizardSafer
  • Safer
  • December 21, 2015

You can read the Excel file and use the FeatureMerger to merge both you data source and the Excel file. All merged features will have the requested value for the join attribute. This will allow you to add values to the process without editing the workspace.

Be sure to set it up so that the Excel file reader is the FIRST reader in your workspace route that data into the Suppliers. Then you can set the FeatureMerger into "Suppliers First" mode which will result in it NOT blocking the Requestors, resulting in a faster running translation @anete

Community Stats

32,154
Posts
122,043
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.