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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to configure tFilelist & tFileInputdelimited to set up dynamic input

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 - 

0683p000009LycK.png

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.
0683p000009LySk.png

0683p000009Lyay.png0683p000009LycP.png

 

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

Labels (2)
7 Replies
TRF
Champion II
Champion II

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

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.
Anonymous
Not applicable
Author

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?

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

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 

Anonymous
Not applicable
Author

How to use Talend Dynamic Schema Feature?
Anonymous
Not applicable
Author

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/2...

Hope it helps.

Best regards

Sabrina