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