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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to have my job run for different schemas dynamically?

Hii,
Can somebody explain how to have my job run with different schema dynamically?
Means my job have some tfileinput written to tlogrow and I am passing the file name to the tfileinputdelimited thru the context variable. I want to display different file contents every time I run this job by passing different file name with different schema to the context variable.
How can I achieve that just by changing the file name provided in the context variable?
P.S:The different file names have different schemas.
Labels (2)
7 Replies
Anonymous
Not applicable
Author

Hi,
I want to display different file contents every time I run this job by passing different file name with different schema to the context variable.

For your requirement, you have to use dynamics schema in schema setting. However, dynamic schema feature is only available in Talend Enterprise Subscription Version, it allows you to design schema with an unknown column structure (unknown name and number of columns).
For more details, please see document TalendHelpCenter:How to process changing data structure?
Best regards
Sabrina
Anonymous
Not applicable
Author

Thanks xdshi for your prompt reply..
But then also by changing the settings as dynamic settings enabled,if I develop a job and I want to make it generic ,using enterprise edition can I do that by just changing the value i.e. file name passed to my context variable which asks for a prompt at the beginning of my job.
Anonymous
Not applicable
Author

Hi,
You can set the file path with context variable or you can use Implicit context load.
Best regards
Sabrina
0683p000009MB0k.png 0683p000009MBKx.png
Anonymous
Not applicable
Author

Thanks xdshi for the support..
Anonymous
Not applicable
Author

Hi,
Don't hesitate to post your issue on forum.
Best regards
Sabrina
Anonymous
Not applicable
Author

Ok Thanks Sabrina. 0683p000009MACn.png..
If you can please see this topic,How to achieve dropping columns based on the metadata file? posted by me..
Thanks in advance..
Anonymous
Not applicable
Author

The link is ..http://www.talendforge.org/forum/viewtopic.php?id=31924