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

Announcements
Discover how organizations are unlocking new revenue streams: Watch 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