Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Read excel file with tjavarow

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,

Labels (3)
6 Replies
akumar2301
Specialist II
Specialist II

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

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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