topic Re: Getting the file name from tfilelist in Talend Studio

Getting the file name from tfilelist

Anonymous — Sat, 16 Nov 2024 04:27:01 GMT

Hello All

I do have a requirement, i wanted to read the file names from tFile list which i did in below method, and able to read the file names

But i need to read the files names and data corresponding to the files , to let me know from which file data came, but when i run the job below, with design

There are 3 files in the files list , am able to see data one after another, but am unable to see from which file the data is came from, what design or method would be better to see that way

right am seeing the data like below format

id, name

1,Manish

------------

id, name

2,Manish

------------

id, name

3,Manish

but i wanted to see in this below format to know from which file it is coming from

File1

id, name

1,Manish

------------

File2

id, name

2,Manish

------------

File3

id, name

3,Manish

Thanks In Advance

Manish

Re: Getting the file name from tfilelist

TRF — Mon, 07 Oct 2019 18:42:00 GMT

Share your tMap

Re: Getting the file name from tfilelist

Anonymous — Mon, 07 Oct 2019 19:05:52 GMT

@TRF Thanks please find below

Re: Getting the file name from tfilelist

TRF — Mon, 07 Oct 2019 19:56:40 GMT

So you want to retrieve the filename in your output, that's it? But you don't do anything for that. Add filename as a new field for your tMap output and use the following expression to populate that field:
(String)globalMap.get(tFileList_1_CURRENT_FILE)

Re: Getting the file name from tfilelist

Anonymous — Mon, 07 Oct 2019 19:59:41 GMT

@TRF Thanks it worked out. but if am using with multiple files, every name is popping with same file name , that is the limitation now

Re: Getting the file name from tfilelist

TRF — Mon, 07 Oct 2019 20:31:43 GMT

I'm sure of not.
You'll have the same filename for every record from the same file and different filenames as soon as the input file will change.