Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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