The problem is that I have to rename the column to fit to the naming conventions ANDI do not know which column gets lagged since this is controlled by a Column Selection Configuration node.
If there would be a rename config within the Lag Column I could use this (=> Feature Request)
If there was any way to rename a column by position, I could do the renaming directly after producing the lag since the lag column is always appended to the right of the table - Is there a way to rename by position?
Jip, this would only work for one column. But would be enough for 99.5% of use cases - and I could propably do a 5 times loop if I want 5 loops and could still rename the columns however I want. E.g. adding ‘(-1)’ as suffix is never an option anyways.
check workflow attached. There you’ll find what I have meant with adding “(-1)” in upper flow and in next flow you can see how to solve this with renaming column which is to be lagged prior to lagging. Hope one of these solutions will work for you.