Forums

I'm trying to setup a readdata that as an IN statement, but I can't seem to get it to accept multiple values. So if I wanted WHERE "ID" IN 1,2 and 3 for example. How would you set it up in the readdata?

Hello
​
Same problem
Nobody to answers at this basic question?
​
Curious!!!

I don't actually remember what I was asking here exactly, not sure which way I went. Maybe with a combination of "or" statements or I had the IN clause fed by another read data. Maybe one of the moderators will help
​
​

Yes, I know, but is very loud
​
With Data Builder, you can do that:
Variable var1 1,2,3,4,5,6,7,8,9,10,11,12,13
Variable var2 {var.split[]:var1}
​
And use var2 on a read_data condition "in statement"...