A general question on the way iterate and append works and why it drops the previous columns
Lets assume a data set has 1 column as seen below
If I iterate and append to look up another column I will add to this as seen below
However, if I add another append it drops the previous columns, as seen here
The only way I can think to get around this is to keep deriving it and stitching things back together by using row number which is something like this:
Is there a better way to handle this type of scenario?