topic Re: comparison between columns of the same excel file in Talend Studio

comparison between columns of the same excel file

Anonymous — Thu, 28 Mar 2019 08:34:17 GMT

Hello everyone,

I have an input excel input file that contains multiple lines I have to make a comparison between each two columns of each line example:

I have the following columns => Object_c1, Object_c2, Object1_c1, Object1_c1 ...

I have to make a comparison between Object_c1 and Objet_c2 and another comparison between Objet1_c1 and Objet1_c2 ...

If it's Ok we do not do anything but if the values are different we send it back to the output file outputexcel and we write the two values of the two columns compared

I hope I was clear enough

Could you please orient me

Regards,

Re: comparison between columns of the same excel file

Anonymous — Tue, 02 Apr 2019 07:10:15 GMT

Hello,

You created a topic about:https://community.talend.com/t5/Design-and-Development/comparison-between-two-columns-of-the-same-excel-file/m-p/154784#M94647

Is it a further issue for you? Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina

Re: comparison between columns of the same excel file

Anonymous — Mon, 08 Apr 2019 15:25:47 GMT

I want to read line by line of a column and returned the value of the line n ° 5 for example

do you have an idea to do this please