comparison between columns of the same excel file

[Anonymous]

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,

[Anonymous]

Hello,

You created a topic about:https://community.talend.com/t5/Design-and-Development/comparison-between-two-columns-of-the-same-ex...

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

[Anonymous]

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