Expression needed

[#1]

Hi,

I have table as below and 4 variables. Need expression for below..

LOAD * INLINE [

    IId, Des

    2, Two

    3, Three

    5, Five

    7, Seven

    10, Ten

];

I need first record of the table Des into Var1.

Second record of the Des into Var2 and so on..

[#2 · Accepted solution]

Try something like below

LET variable1 = PEEK('Des',0,'Demo');

LET variable2 = PEEK('Des',1,'Demo');

LET variable3 = PEEK('Des',2,'Demo');

LET variable4 = PEEK('Des',3,'Demo');

[simondachstr]

for i=1 to FieldValueCount('Ild')

Let $('Var'&i)                = peek('Des',$(i))

NEXT i

[#4]

Hi Martin,

Thanks. It is working.

[#5]

Hi Kiruthi,

Thanks it is working.