topic Re: Browse folders and find identical files (without using tFileCompare) in Talend Studio

Browse folders and find identical files (without using tFileCompare)

Anonymous — Thu, 09 Aug 2012 11:13:44 GMT

HI,
I try to browse two folders and see if I find in the two, files with the same name (my files in my folders are named with an ID and I have to parse the file names and compare to see if I have this ID)
for exmaple :
File1=Toto1-12345.csv in folder 1
File2=Toto2-12345.csv in folder 2
Result OK : I have the same ID 12345

I can not use a tFileCompare because they come from two different systems (different moment, different filename, different ref....)
an idea how I could do?
I tried: tFileList_1----OnComponnentOk----tFileList_2------iterate------tJava. but it doesn't work. In my tJava I tried (if (String)globalMap.get("tFileList_1_CURRENT_FILE")==(String)globalMap.get("tFileList_2_CURRENT_FILE") ....)
Thanks

Re: Browse folders and find identical files (without using tFileCompare)

alevy — Thu, 09 Aug 2012 15:55:28 GMT

Something like:
tFileList_1 --> tIterateToFlow (file names) --> tJavaRow (parse ID) --main--> tMap (inner join) -->
tFileList_2 --> tIterateToFlow (file names) --> tJavaRow (parse ID) --lookup-->

Re: Browse folders and find identical files (without using tFileCompare)

Anonymous — Thu, 09 Aug 2012 15:57:41 GMT

Hi
In Java, use the method String1.equals("String2") to check one string if equlas to anther string. In your case, the expression should be:
(String)globalMap.get("tFileList_1_CURRENT_FILE").equals((String)globalMap.get("tFileList_2_CURRENT_FILE") ....))
Best regards
Shong

Re: Browse folders and find identical files (without using tFileCompare)

Anonymous — Fri, 10 Aug 2012 09:39:00 GMT

Thanks both
I tried

Something like:
tFileList_1 --> tIterateToFlow (file names) --> tJavaRow (parse ID) --main--> tMap (inner join) -->
tFileList_2 --> tIterateToFlow (file names) --> tJavaRow (parse ID) --lookup-->

But impossible to retrieve my data from tJavaRow in my tMap.

Re: Browse folders and find identical files (without using tFileCompare)

alevy — Fri, 10 Aug 2012 09:52:16 GMT

tJavaRow just allows you to manipulate the row variables so there's no reason it shouldn't be available in tMap if you've done it properly. How about a screenprint?

Re: Browse folders and find identical files (without using tFileCompare)

Anonymous — Fri, 10 Aug 2012 10:22:25 GMT

Thanks alevy,
maybe I'm wrong in setting my tJavarow

Re: Browse folders and find identical files (without using tFileCompare)

alevy — Fri, 10 Aug 2012 13:36:23 GMT

All you've done is declared a local variable. If you want the value passed out, the code should be something like row3.name_file=row1.filename;. (You can also use input_row and output_row instead of the actual row names.)

Re: Browse folders and find identical files (without using tFileCompare)

Anonymous — Fri, 10 Aug 2012 16:09:23 GMT

works! thanks

Re: Browse folders and find identical files (without using tFileCompare)

Anonymous — Tue, 24 Jun 2014 08:19:07 GMT

please can any one tell me how to use tFileCompare

Re: Browse folders and find identical files (without using tFileCompare)

Anonymous — Tue, 24 Jun 2014 08:27:16 GMT

Not sure how talend checks internally, but the tFileCompare performs the comparison for the contents inside the file on line by line basis... see the code below
while ((content_tFileCompare_1 = file_tFileCompare_1
.readLine()) != null
&& (contentRef_tFileCompare_1 = fileRef_tFileCompare_1
.readLine()) != null) {
if (content_tFileCompare_1
.compareTo(contentRef_tFileCompare_1) != 0) {
result_tFileCompare_1 = false;
break;
Refer to following URL for use case
https://help.talend.com/search/all?query=tFileCompare&content-lang=en
Thanks
Vaibhav