How to get column name and column value when using dynamic command MSSqlInput

[ngoctuan04th2]

Dear all,

I have a MSsqlinput , inside have 1 query command "select * from sec" (it can dynamic not fixed ) so i not create schema for it.

How to get column name and column value by Tjava or not ?

Thank you very much.

[Anonymous]

In this case you want to add a column that has type Dynamic.

Columns will be mapped to that single object.

You could also read about it here: https://help.talend.com/r/en-US/8.0/dynamic-schema/tsetdynamicschema-tfileinputpositional-tfileoutputpositional-tfixedflowinput-configuring-second-subjob-reading-and-writing-positional-data-standard-component-enterprise

And this JIRA has some java code: https://jira.talendforge.org/browse/TDI-48091