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
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