How do you do a LOAD with a WHERE clause that has an IN (...,...,..) statement. In other words I want my where condition to have multiple instances.
You can use Match() in place of IN()
Using IN clause in QlikView – Learn QlikView
rowno() as Field1,
rand() * 100 as Field2
where match(Field1, 1, 2, 3, 4, 5, 100);
DROP Table test;
If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).
If not, please make clear what part of this topic you still need help with .
Retrieving data ...