Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
manojkulkarni
Partner - Specialist II
Partner - Specialist II

Excel Data Transformation

HI Friends,

I have attached the sample data in excel. I would need your help/suggestion on how this data can be loaded into qvw as 2 tables.

14 Replies
avinashelite

If you have got the answer mark the helpful and correct answers

manojkulkarni
Partner - Specialist II
Partner - Specialist II
Author

I didn't understand the statement not wildmatch(Column2,'*Column*') ? Why we would need this ?

avinashelite

wildmatch(Column2,'*Column*')


wildmatch is case insensitive , it will try to compare the value of the parameter 1 with 2nd if the match is found it will return true ..using this we can validate the conditions according to our need

tamilarasu
Champion
Champion

We need to exclude the header names (Column11, Column 12 and Column 13) in table 2. So the above syntax checks the column1 whether any cells contains "Column*" and  excluds that specfic row.

manojkulkarni
Partner - Specialist II
Partner - Specialist II
Author

Thanks for your suggestion.