I am working on FME 2013 with XP machine and I want to run SQL query. I used InlineQuerier, SQLExecuter, SQLCreator but none of them is compatible with my requirement. I want to run SQLQuerry on a shapefile and give me the selected outputs like –
Select * from N_12 Where HNR1 Is Null
InlineQuerier is giving the output but it is only providing two automated columns(OID and Shape). Are there any other solutions or I am doing something wrong?
Actually, none of the above suggestions are working appropriately and is not fitting in my criteria. I am working on NULL and REPLACE, and I am not able to reach to get my destination till now.
Best Answer
You can add Shapefile reader and add tester there.
Edit: looks like people want more content to this.
Readers -> Add reader -> Add shapefile And in workspace draw lines in order : Shapefile -> Tester (select value and test) -> AttributeSetter/Replacer/Creator for replace
Shapefile -> AttributeFilter -> AttributeSetter is other option.
InlineQuerier looks like "slow" (not 100% sure about it) solution, because it may force workspace to read all input features into it , process and after that pipe data to next transformer.