How to use a table field as a variable ?

[#1]

Hi,

I just need to know if this is possible.

Once you write the load statement, can I add a where clause to assign a particular value to a variable ?

Example:

SET X= Load FieldValue resident tablename where Fieldvalue='Y';

[deepakk · Accepted solution]

hi Chinmay,

You can use it like

Load fieldValue from table where Fieldvaleu= 'Y';

let vtest = peek('Fieldvalue',0,'tablename');

I hope this helps.

[tresesco]

i think you need something else, otherwise what you wrote is equivalent to

Set X='Y'; if you already know the value then, why not this ? if you are in a different situation, please explain a bi t.

Regards, tresesco

[#4]

Thanks a lot Deepak

[#5]

Hi,

I got this working and was trying to use this variable in the where clause but not able to do.

Example:

Load Statement;

let vtest = peek('Fieldvalue',0,'tablename');

Load Statement where Column=$(vtest);