Discussion Board for collaboration on QlikView Scripting.
Hi, I want to copy the values of one table to another table using a for loop?
Go to Solution.
You can very well use this sample
LOAD *, SubField(States,',') AS StatesUpdated Inline
LET vTotalRows = NoOfRows('Table1');
FOR i=0 to vTotalRows-1
Peek(StatesUpdated,$(i),'Table1') AS NewField
Can you explain the issue clearly it may be done without using for loop also. I helps us to figure it out for you.
Hi, I know you can somehow use a join or concatenate
But for know I want to use a for loop, because I want to do some other stuff within the loop.
So lets say I have table A with fields A1, A1
Which I want to copy to table B with fields B1, B2, B3 so that the values of
B3 becomes A1 for e.g
And if you want to add to an exixting table?
Let's say that in your case table Test already existed?
Based on which condition you have to add a field to existing one?