topic Re: Compare excel file in different folder in Talend Studio

Compare excel file in different folder

Ven6 — Sun, 01 Mar 2020 19:52:53 GMT

Hello I have a problem.
I have two folders (new_folder and old_folder) with 50 excel files each.

I would like to create a job that compares each file in the folder new_folder with those in the folder old_folder folder.
either file1 in the new_folder folder compares to file1 in the old_folder folder; either file2 in the new_folder folder compares to file2 in the old_folder folder so on ... the files are in the format file_date (yyyMMdd). extension example: the first file in the folders is file_20200101.xlsx

Out of it I would like to have different lines.

help please

Re: Compare excel file in different folder

Anonymous — Mon, 02 Mar 2020 03:14:16 GMT

Does the file name is the same in both folder?

Re: Compare excel file in different folder

Ven6 — Mon, 02 Mar 2020 06:53:38 GMT

Yes it's the same

Re: Compare excel file in different folder

Anonymous — Mon, 02 Mar 2020 07:43:54 GMT

It is possible to compare the file contents with tFileCompare component, and return the result that shows the two files are identical or differ.
For example:
tFileList1--iterate--tFilecompare--runIf--tFixeFlowInput--main--tFileOutput

tFileList: iterate each files in new folder
on tFileCompare:
set the File to compare filed as:
((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))
set the Reference file field as:
"your old folder/"+((String)globalMap.get("tFileList_1_CURRENT_FILE"))

If the files are differ, output the current file name to a file, set the condition of runIf as:
!((Boolean)globalMap.get("tFileCompare_1_DIFFERENCE"))

on tFixedFlowInput: generate the current file name, define one column and set its value as:
((String)globalMap.get("tFileList_1_CURRENT_FILE"))

Regards
Shong

Re: Compare excel file in different folder

Ven6 — Mon, 02 Mar 2020 08:55:51 GMT

Tks for this

but ,

I would like to have output different lines from each compared file.