topic Re: How to configure tFilelist & tFileInputdelimited to set up dynamic input in Talend Studio

How to configure tFilelist & tFileInputdelimited to set up dynamic input

Anonymous — Fri, 08 Jun 2018 21:47:57 GMT

Hello,

Here is my situation -

I created 6 filedelimited under Metadata previously for my job input (i.e. USISV) but now I have to use dynamic Input (i.e. ILUSISV_D20180608053000.KRLOGN.ZZLGNT) for my job - we plan to connect with FTP to get those Inputs automatically. so I configured tFilelist as below -

But I am not sure how to configure tFileInputdelimited to get one of the file (i.e. USISV). I put below but not work - nothing show in Tmap.

Thank you so much if you can help me solve this problem!

Re: How to configure tFilelist & tFileInputdelimited to set up dynamic input

TRF — Fri, 08 Jun 2018 22:05:30 GMT

Does your filemask matches with réal filenames?
There is no extension on filenames such as .csv or anything else ?

Re: How to configure tFilelist & tFileInputdelimited to set up dynamic input

Anonymous — Mon, 11 Jun 2018 15:36:15 GMT

Hi,

Files I use will be updated daily with different timestamp, such as "ILUSISV_D20180611053001.KRLOGN.ZZLGNT so currently everyday I need to manually change into general file name such as "USISV".
For my Filemask, I put "ILUSISV_*.KRLOGN.ZZLGNT" and I also include other 5 files for different job needs.

Re: How to configure tFilelist & tFileInputdelimited to set up dynamic input

Anonymous — Mon, 11 Jun 2018 15:50:44 GMT

Also, there is an error message in my tFileInputDelimited - "no schema has been defined yet" and I am not sure how to import those schema from tFileList to tFileInputDelimited just like I did in "Matadata - file delimited" part.
I have 6 different files do I need to create 6 different tFilelist as well?

Re: How to configure tFilelist & tFileInputdelimited to set up dynamic input

Anonymous — Wed, 13 Jun 2018 10:25:30 GMT

Hello,

You need to use talend dynamic schema feature in your tfileinputdelimited component if your 6 different files have different schema structure.

Best regards

Sabrina

Re: How to configure tFilelist & tFileInputdelimited to set up dynamic input

Anonymous — Wed, 20 Jun 2018 19:23:44 GMT

Hi,

Have same data structure, the difference will only be the file name - for example, now I use "USISV" as file name but I want to change to USISV_(current date) for the input

Re: How to configure tFilelist & tFileInputdelimited to set up dynamic input

Anonymous — Sat, 23 Mar 2019 14:03:30 GMT

How to use Talend Dynamic Schema Feature?

Re: How to configure tFilelist & tFileInputdelimited to set up dynamic input

Anonymous — Mon, 25 Mar 2019 05:26:37 GMT

Hello @saibharadwaj

Talend dynamic schema feature is available in talend subscription solution.

Please refer to this community knowledge about:https://community.talend.com/t5/Design-and-Development/How-to-process-changing-data-structure/ta-p/21702

Hope it helps.

Best regards

Sabrina