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
manodwhb
Champion II
Champion II

@didi ,can you verify the below screenshot,this way you need to implement0683p000009M48b.png.

Anonymous
Not applicable
Author


thank you for your return,
please if I want to tell him the line to recovered I do how
thank you
manodwhb
Champion II
Champion II

@didi ,not understand your question,could you please elaborate ? 

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
manodwhb
Champion II
Champion II

@didi ,you can do below way. since i have taken two columns.

0683p000009M48v.png0683p000009M490.png

Anonymous
Not applicable
Author

your code works very well thank you.
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