Skip to main content
Solved

hidden attributes SQLCreator


boubcher
Contributor
Forum|alt.badge.img+11

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

Best answer by erik_jan

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:

View original
Did this help you find an answer to your question?

6 replies

erik_jan
Contributor
Forum|alt.badge.img+18
  • Contributor
  • Best Answer
  • January 11, 2017

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:


boubcher
Contributor
Forum|alt.badge.img+11
  • Author
  • Contributor
  • January 12, 2017

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


nielsgerrits
VIP
Forum|alt.badge.img+54
boubcher wrote:

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

@boubcher It's not clear to me what you need exactly but there is a reason why you can't auto expose attributes: Transformers can often not be configured for unknown attributes. If you want to dynamic translate data the FeatureReader and FeatureWriter do all the magic in my opinion. It took me a while to get used to this way of thinking but I don't know how I ever could do without these.

 


boubcher
Contributor
Forum|alt.badge.img+11
  • Author
  • Contributor
  • January 13, 2017

but how do you pass the Table name you want to read from the DataBase in order to get all features,


nielsgerrits
VIP
Forum|alt.badge.img+54
boubcher wrote:

but how do you pass the Table name you want to read from the DataBase in order to get all features,

The same way you do when using the SQLCreator. As attribute or parameter input in the field FeatureTypeToRead.

 


fmelizard
Safer
Forum|alt.badge.img+19
  • Safer
  • January 15, 2017
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.

 

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings