+13Hello
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
Best answer by nielsgerrits
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 = 5250For the FeatureReader the Where clause will work on all selected tables.
+54Not 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 = 5250For the FeatureReader the Where clause will work on all selected tables.
+13Not 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 = 5250For the FeatureReader the Where clause will work on all selected tables.
Thanks
objectid = ‘5250‘
it works
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
