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