Skip to main content
Solved

Select only certain values in excel spreadsheet column


simonhume
Contributor
Forum|alt.badge.img+2

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.

View original
Did this help you find an answer to your question?

2 replies

redgeographics
Celebrity
Forum|alt.badge.img+49
  • Celebrity
  • Best Answer
  • June 21, 2018

You could use the Tester or TestFilter to do that.


simonhume
Contributor
Forum|alt.badge.img+2
  • Author
  • Contributor
  • June 21, 2018

@redgeographics

thanks for your prompt answer, the workspace is now working fine

Simon Hume


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