How to get a File Name

[A_San]

I am trying to get the file name of a file that I am trying to load to postgres database.

I see that we need to use tFileList_1_CURRENT_FILE for the current filename. Where do I give this command?

tfilelist ->tfileInputDelimited->tDBOutput is what I have right now. 

[Anonymous · Accepted solution]

Assuming you are loading the file and retrieving its contents using the tFileInputDelimited, you will need to add a tMap between the tFileInputDelimited and the tDBOutput. In the tMap add another column on the output table (the data being sent to your tDBOutput) and populate it with ....

((String)globalMap.get("tFileList_1_CURRENT_FILE"))

For every row of data returned by your file, you will also get the file name.