Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I import a excel like this:
Articles:
LOAD
Article,
MinAnt,
MaxAnt
FROM
Then I want to use theese values in my sql query like this:
Select Article, Maxant - CurAnt FROM values
WHERE CurAnt > MinAnt
How can I use the values from Excel in my sql query?
Thanks in advance!
I tried this:
Articles:
LOAD
Article,
MinAnt,
MaxAnt
FROM
Temp:
Select Article, CurAnt FROM values;
left join(Articles)
Load *
RESIDENT Temp;
Can you please tell me how to write a SQL query that uses MinAnt and MaxAnt...
Any help is appreciated.
Thanks.