Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

store variables' values in a table

Hello

I'm looping through the records of a table

For i=1 to NoOfRows('MyTable')

     if condition is true then

          let v1 = FieldValue('myColumn',$(i));

          //here I want to store v1 in a table and everytime I set v1 I want to concatenate the value of V1 into a new row in the same table

     endif

next

Please advise

I can walk on water when it freezes
1 Reply
swuehl
MVP
MVP

Try maybe some similar to this:

For i=1 to NoOfRows('MyTable')

     if $(i)<5 then // or any other condition check, as you like

          let v1 = FieldValue('myColumn',$(i));

    ResultTable:

    LOAD

    $(v1) as Result

    autogenerate 1;

     endif

next