Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ngoctuan04th2
Contributor II
Contributor II
‎2023-10-03 03:29 AM

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

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.

0695b00000mRMs1AAG.png

Labels (7)
517 Views
1 Reply
Anonymous
Not applicable
‎2023-10-09 09:20 AM

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

 

517 Views
0 Likes