topic Re: getting filename from tFileInputDelimited in Talend Studio

getting filename from tFileInputDelimited

Anonymous — Sat, 16 Nov 2024 12:21:05 GMT

Hi!
I'm trying to insert the filename into my target table. Im using tFileInputDelimited and tmap.
In tmap i put in this in the expression editor:
((String)globalMap.get("tFileInputDelimited_1_CURRENT_FILE")), but only question marks are inserted into the tables.
Any thoughts on how to do this properly?
Thanks!

Re: getting filename from tFileInputDelimited

Anonymous — Thu, 23 Feb 2012 09:33:27 GMT

Hi
You can't get file name from tFileInputDelimited. Because there isn't tFileInputDelimited_1_CURRENT_FILE in Talend job code.
Regards,
Pedro

Re: getting filename from tFileInputDelimited

Anonymous — Thu, 23 Feb 2012 09:57:24 GMT

got it, will be using fileproperties.

Re: getting filename from tFileInputDelimited

Anonymous — Thu, 23 Feb 2012 09:59:41 GMT

Hi,
I don't know how you have designed your job, but one way would be to use a tFileList component to achieve your requirement.

Re: getting filename from tFileInputDelimited

Anonymous — Thu, 23 Feb 2012 10:17:37 GMT

tFileList is not useful for me, since all my files have different schemas.

Re: getting filename from tFileInputDelimited

Anonymous — Sun, 08 Feb 2015 16:35:04 GMT

I have the same requirement and needs to get the current name of input.
Lets say, input file name is a.txt. I want the output file name is a_output.txt. How can I do it?
please help.