Solved

How to filter the output from feature reader when id = specific no. From all tables that read

+13

Hello

i am reading many tables from oracle non spatial

tables name

Table_A

Table_B

Table_C

i have around 30 table

and I would like to get the Output from all tables when Id= 45

i am not sure ,how to write the condition in where clause to test it in all tables

and In case it did not find the id in any table so I will not get any output from this table .

But in case also ,no id as attribute name in any table so I get nothing better than error ,if it is possible .

Fme 2021

icon

Best answer by nielsgerrits 1 May 2023, 13:41

Userlevel 6

+32

Not having Oracle DB here so I can't test it, but I assume you can simply use the Where clause and enter something like

objectid = 5250

For the FeatureReader the Where clause will work on all selected tables.

+13

Not having Oracle DB here so I can't test it, but I assume you can simply use the Where clause and enter something like

objectid = 5250

For the FeatureReader the Where clause will work on all selected tables.

Thanks

objectid = ‘5250‘

it works

Sign up