Solved

Select only certain values in excel spreadsheet column

Forum|Forum|7 years ago
June 21, 2018
2 replies
16 views

+2

simonhume
Contributor

Hi

Can someone advise me what the easiest method there is to select only certain records from an excel spreadsheet, based on one column?

I have a simple excel spreadsheet listing bin deliveries to addresses as individual cases from our CRM system. One of the columns is whether the case is Open or Closed

One of my FME workspaces is configured to map all these into SHP format, which i've succesfully done

The other workspace now needs to also map these, but only where the case is Open.

I've tried the Attribute based Transformers, but can't get the correct output

Any help much appreciated

thanks

Simon Hume

Best answer by redgeographics

You could use the Tester or TestFilter to do that.

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.