Skip to main content
Solved

AttributeFilter - possible attribute values - multiline

  • December 18, 2015
  • 5 replies
  • 28 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.

View original
Did this help you find an answer to your question?
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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+17
  • 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+17
  • 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+43
  • 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

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
Contributor
Forum|alt.badge.img+17
  • fmelizardContributor
  • Contributor
  • December 21, 2015
erik_jan wrote:

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

Helpful Members This Week

Community Stats

30,985
Posts
117,436
Replies
38,765
Members

Latest FME

Terms & ConditionsCookie settings

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
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.