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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

check availability

hi, i want to check 3 excel sheets to if they are having my items. if they have i want to create a column with 'yes'. how can i do that?

4 Replies
Anonymous
Not applicable
Author

Post some sample to better understand your requirement,

Regards

Nitin

Not applicable
Author

Hi Chathurnaga,

I am not realize clearly, please post sample excel or script,

Try to add, when you are load data from excel file ADD where clause, then add concat or “&’ with column name in resident table.

jagan
Partner - Champion III
Partner - Champion III

Hi,

Can you come up with some sample data and explain.

Regards,

Jagan.

Not applicable
Author

hi, sorry guys. found the solution. thanks