Where clause with 2 variables.

[kikerodriguez10]

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!

[vishsaggi]

Try this

Let vVariable1=5;

Let vVariable2=10;

Table:

Load Field1,

         Field2,

         Field3

From Document

WHERE Field1 > '$(vVariable1)' and  Field1 < '$(vVariable2)';

[kikerodriguez10]

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!

[devarasu07]

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

[vishsaggi]

What are the values you hold in your Field1 column? Can you share some sample data to look into. ?

[Clever_Anjos]

It seems correct to me, unless Field1 has a different format