Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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()
test:
LOAD
rowno() as Field1,
rand() * 100 as Field2
AutoGenerate 100;
output:
NoConcatenate load
*
Resident test
where match(Field1, 1, 2, 3, 4, 5, 100);
DROP Table test;
Thanks.
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 .