Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try maybe some similar to this:
if $(i)<5 then // or any other condition check, as you like
ResultTable:
LOAD
$(v1) as Result
autogenerate 1;