Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone!
I need to use two variables in a where clause. I try with this syntax but I did not succeed:
Let vVariable1=5;
Let vVariable2=10;
Table:
Load Field1,
Field2,
Field3
From Document
WHERE Field1 > $(vVariable1) and Field1 < $(vVariable2);
Anyone know the correct syntax for this example?
Thanks in advance!
Try this
Let vVariable1=5;
Let vVariable2=10;
Table:
Load Field1,
Field2,
Field3
From Document
WHERE Field1 > '$(vVariable1)' and Field1 < '$(vVariable2)';
Thanks for your help @Vishwarath Nagaraju !
I tried it but did not work, also I tried with double quote but neither work.
Any other syntax?
Thank you very much!
Hi,
Seems like some data format issue . can you share some mock data and expected output. that would be easy for us to check and share our suggestions. Thanks
Thanks,
Deva
What are the values you hold in your Field1 column? Can you share some sample data to look into. ?
It seems correct to me, unless Field1 has a different format