Working with Loop without multiplying the rows

Hello,

I need a best practice solution for the following topic.

Starting point:
I have several columns for which I want to add the values with the respective column name.

Basically I could solve it with the loop nodes. Does it multiply the rows per iteration.

Unfortunately, I have not yet found a solution.

Do you have any ideas?

BR

Hi @AndreAndre , the problem with your loop here is that you are using Table Row to Variable Loop, but then within the loop, you are pulling in the entire input Table on each iteration, when the Table Creator feeds to Column Renamer. Therefore, each iteration will return a copy of the whole table. This is why you see the rows being multiplied.

So you are trying to take the original data and replace all the data in the non-id columns with columnname!cellvalue ?

You can achieve this with a Column List Loop as follows:

apply column names to cell values.knwf (81.6 KB)

1 Like

Hi takbb.

Works! Thanks!

BR

Andre

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.