topic Re: Check if multiple files exist in Talend Studio

Check if multiple files exist

Anonymous — Sat, 16 Nov 2024 12:44:17 GMT

Hi,
Is someone able to explain to me what components to use and how I can do the following?
I have a table which references a path and filename of a collection of files location on a mapped network drive.
I want to be able to iterate through each row of the table, and then based on the path and filename, confirm that the file actually exists.
I've had a look at the tfileexist component but this does not seem to take a file path input.
Thanks,
Simon

Re: Check if multiple files exist

Anonymous — Wed, 17 Aug 2011 02:32:11 GMT

Hi Simon
tFileExist is the suitable component to check if the file exist or not, the job looks like:
tMysqlInput--row1--tFlowToIterate--iterate---tFileExist
Assuming that you query two fields from the table: filepath and filename
in the filename/stream field of tFileExist:
row1.filepath+"/"+row1.filename
Best regards
Shong

Re: Check if multiple files exist

Anonymous — Wed, 17 Aug 2011 02:52:53 GMT

Thanks Shong.
1 more basic question. I now need the id, filename and a true / false (if exists) to be written to file.
How to I capture the result of the tfileexist component to output?
Thanks,
Simon

Re: Check if multiple files exist

Anonymous — Wed, 17 Aug 2011 02:57:04 GMT

Thanks Shong.
1 more basic question. I now need the id, filename and a true / false (if exists) to be written to file.
How to I capture the result of the tfileexist component to output?
Thanks,
Simon

Base on your request, the job looks like:
tMysqlInput--row1--tFlowToIterate--iterate---tFileExist_1--oncomponentok--tFixedFlowInput--main--tFileOutputDelimited
on tFixedFlowInput, add three columns on the schema: id, filename and isExist
columnName:value
id Integer)globalMap.get("row1.id")
filename String)globalMap.get("row1.filename")
isExist (Boolean)globalMap.get("tFileExist_1_EXISTS"))
on tFileOutputDelimited, check the box 'append'
Best regards
Shong