Skip to main content

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

You could use the Tester or TestFilter to do that.


@redgeographics

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

Simon Hume


Reply