Hi, I want to copy the values of one table to another table using a for loop?
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
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
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?
Retrieving data ...