How to generate an Excel file which consist of source path of the file as well as the filename.

[Aish123]

Hi,

I have list of folders on my local system which consists of different files(.png,.pdf,.doc,.xls,etc.)

I want to generate an Excel file which consist of source path of the file as well as the filename.

How can i achieve this task using talend?

Please find the attached job which extracts the filename present in the folder "C:\Images" and stores in an excel file.

But like this there are multiple folders for which i need to extract the filepath as well as the filename in an excel file.

Please help.

[Anonymous]

Hi,

    Could you please try below method?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Aish123]

Hi Nikhil,

Please find the attached job created as per the solution you provided.

But when i run this job i am not able to fetch anything.

What exactly needs to be present in the "tFileinputDelimited"?

Where we need to specify the path of the folder from where the files are going to get picked up.

It would be helpful if you create a job and attach the screen print of it in this solution.

tRowGenerator.PNG
tFileList1.PNG
tFileInputDelimited.PNG
NewJob.PNG

[Anonymous]

Hi,

    In the first csv, you need to specify the list of folders which need to be scanned. Once you give the details, it will scan those folders and pick the corresponding files.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Aish123]

Hi,

I have an excel sheet which consist of a column "Source" inside which there is a "filepath location" which for e.g. is "C:\Trades\Trade01\Images".

I have to use this excel sheet as the input for fetching the "filenames" of the files which we will be present inside this "Images" folder.

How will i be able to achieve this using the Talend.

The input excel file consist of "different filepath locations".So i want to generate such an output excel file which will have the filepath exactly same as the input file and along with this the filenames of the files present inside the folder.

Please help. 

[Anonymous]

Hi,

    Your overall solution looks fine. Could you please add print in each stage using tLogrow or tJava to see the output in each section especially the variables generated from previous components. This will give you clue for the flow.

Warm Regards,

Nikhil Thampi