Hello,
I set up a Variable as : SET DataEntryID = '3,30' in the main tap in script; The reason I gave more than one values here, is becuase the value may change when migrating data from other system from time to time. So today the DataEntryID is 3, but tomorrow the ID could be 30. Therefore, I can easily change the value in Variable, instead of change the code/script from place to place. And I want to keep both values, or even more than 2 values in the variable.
What I am interested in is to use the this Vriable list in WHERE Clause. I did this:
LOAD
Case_ID,
FR_STATE_ID,
TO_STATE_ID
From Table name
Where TO_STATE_ID <= DataEntry;
However, this doesn't work. I am thinking it maybe the syntax was wrong? Please kindly let me know how I can make it work.
Thank you in advance for your help,
Becky
