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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tFileOutputDelimited dynamic file name

I'm at a bit of a loss on this one. I currently have a tFileList and tFileInputExcel running so that multiple excel files are checked and have data extracted from them. I then have that data output as a Delimited file. My question is how do i make the tFileOutputDelimited change the name of the file to whatever the input stream is. For instance say I'm running this on 3 excel files, Excel1, Excel2, and Excel3. How do i set the output so that it will create separate delimited files for Excel1, Excel2, and Excel3. I've attached a snapshot of my process so far (it works fine but puts it all in one file). Any help is much appreciated!
Thanks,
Ryan
0683p000009MEpT.png
Labels (2)
2 Replies
Anonymous
Not applicable
Author

I guess you use as file name for tFileInputExcel: ((String) globalMap.get("tFileList_1_CURRENT_FILEPATH"))
I would use nearly the same for the tFileOutputDelimited: ((String) globalMap.get("tFileList_1_CURRENT_FILEPATH")) + ".txt"
Anonymous
Not applicable
Author

ohh alright thanks a ton!