I am currently trying to reproduce an Alteryx workflow in which the “Generate Row” is used. Basically, I am trying to duplicate rows that meet the condition ''RowCount<Quantity". The RowCount starts with 1 and increments by “RowCount+1” every time the condition is true. Whenever it’s false it goes to the next row until all possible rows are duplicated. I think I need a loop but what i’ve done so far does not work.
I think it’s a little bit more complicated, the row has to duplicate every time the condition is met, so if quantity is equal to 9, the row will duplicate itself 9 times so the rowcount will incremeny by 1 at every instance, let me show you an example of what is done in alteryx
Nice one @takbb . I didn’t know about the One Row to Many node. I knew about the One to Many node, which was not working for this, I thought it was supposed to do One (Row) to Many. So they’re actually 2 different nodes.
Thanks @bruno29a! I guess it’s an often overlooked little node. Only used it a couple of times myself, but definitely a great little one for the toolset…