Hi,
In SQL you can create a table and a loop and in the loop you add everytime a record to the same table
create table table_A
( ID. Integer,
Desc varchar
)
declare @loop int
set @loop = 1
while @loop < 10
BEGIN
Insert into table_A
Values(@loop, ‘some text’)
Set @loop = @loop + 1
END
How can I do this in Alteryx?
I played with the iteration Marco, but I can't find the option to append to the same table
Any idea how to do this?
thanks
RJ
