Skip to main content
  • EN

Hi, I am using a sql executor reading dynamically some data from our db. I am using following query: 

select * from t_@Value(F_CLASS_NAME) where fid=@Value(FID). How can I expose the attributes of each query ? I can not use the attribute exposer of the sql executor as the attributes name and number change depending on the table name. I tried a few things but nothing has worked so far. I am reading about 10-40 tables so I want to avoid to manually type in all diff attribute names.

What is the workflow you try to achieve? Because if you do not know the attributes before runtime, you can’t assign them in the transformers either… 

If you want to do some dynamic writing you have several options, but the SchemaScanner combined with a dynamic FeatureWriter is probably the best way to go.

Reply


Community Stats

30,351
Posts
115,341
Replies
38,081
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.