Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
If you have got the answer mark the helpful and correct answers
I didn't understand the statement not wildmatch(Column2,'*Column*') ? Why we would need this ?
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
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.
Thanks for your suggestion.