dynamic file path in tfileinputdelimited

One Star

dynamic file path in tfileinputdelimited

Hi team,
I want to create a job in the following format:
toracleinput -> tfileinputdelimited
The tfileinputdelimited component's file path should be given dynamically. i.e while running the job, it should prompt and ask the path. I used context but i need to type the path over there. But i want to browse the path again while running the job. Is this possible..

Thanks in advance
Regards,
Hermione
Seventeen Stars

Re: dynamic file path in tfileinputdelimited

You can configure the context variable as prompt. To do that open the context view, switch to the Values as tree tab and here you can switch on the usage as prompt.
If you want set file names it is recommended to uses the type File instead of String. The technical datatype is String but the prompt provides an file chooser dialog.
One Star

Re: dynamic file path in tfileinputdelimited

Thanks a lot shong Smiley Happy it is fine now.. i used file as data type and now i got it.. Smiley Happy thanks Smiley Happy
One Star

Re: dynamic file path in tfileinputdelimited

Hi shong,
One more addition in the requirement.

Now, i need to used 5 sub jobs in a job. File path should be same and file name should be different.
So, when i use the context, it should prompt for the path alone and not the file name. Is this possible..
thanks in advance

Regards,
hermione

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog