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

29,744
Posts
113,078
Replies
37,403
Members
Terms & ConditionsCookie settings