topic Re: Read excel file with tjavarow in Talend Studio

Read excel file with tjavarow

Anonymous — Thu, 28 Mar 2019 15:54:35 GMT

Hello everyone,

I have an excel file as input and I would like to read line by line and each column of the file using a tjavarow, but I can not can you please orient me

Regards,

Re: Read excel file with tjavarow

akumar2301 — Thu, 28 Mar 2019 16:10:37 GMT

What is error you are getting . Ideally it should work.

Re: Read excel file with tjavarow

Anonymous — Thu, 28 Mar 2019 16:12:33 GMT

@didi Where you loading after you read, are you applying any logic in tJavarow?

Re: Read excel file with tjavarow

Anonymous — Thu, 28 Mar 2019 16:19:41 GMT

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

Re: Read excel file with tjavarow

Anonymous — Thu, 28 Mar 2019 16:29:27 GMT

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

Re: Read excel file with tjavarow

Anonymous — Thu, 28 Mar 2019 16:35:25 GMT

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, Object_c1, Object_c1 ...

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

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

I hope I was clear enough

Re: Read excel file with tjavarow

Anonymous — Thu, 28 Mar 2019 16:36:31 GMT

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, Object_c1, Object_c1 ...

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

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

I hope I was clear enough