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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
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