Is there a way to expose the hidden attribute when we use the SQLCreator but the table name is entered as published parameter, ( select * from dbo.[$(table_name)] )
the inspector is showing only one column, with no list of all the attributes
Page 1 / 1
The SQLCreator has a field to enter the attributes that need to be exposed.
You can enter them by typing the names of the attributes.
See image below:
I know , but the problem is we don t now the attributes name , since the table name is set as published parameter and it will be giving only when we run the worksapce , and we have a loot of tables
I know , but the problem is we don t now the attributes name , since the table name is set as published parameter and it will be giving only when we run the worksapce , and we have a loot of tables
but how do you pass the Table name you want to read from the DataBase in order to get all features,
but how do you pass the Table name you want to read from the DataBase in order to get all features,
We should ask what the reason is that you want the attributes exposed. Do you want to have them written automatically to an output format? Then the instructions RE: Dynamic schema and FeatureReader make sense. Do you want to use the attributes further downstream as parameters to other transformers? That can work but only if all tables you'd ever plan to use have the attributes in question. If you just want to inspect them in the data inspector, FME 2017 has a "Columns" button that will allow you to see them there.