Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rafael5958
Creator
Creator

excel warning message

Hi everyone.

How can I check for columns in my excel files and retrive a warming message  if a column doesnt exists on a list?

For exemple:

table1.xls

name1   name2

mary    mary

mary    mary

  

table2.xls

name2    name3    name4

peter    peter    peter

peter    peter    peter

table3.xls

name1  name5

tom    tom   

tom    tom 

I want have on my script some array with [name1, name2, name3] and check in all my xls files and warning me that name4 on table2 and name5 on table3 were not found in the array.

0 Replies