Merging two value counter

[jtamasi]

Hi all,

I’m sure it’s basic but I just can’t find the solution…

I have two “value counter” nodes output and I’d like to merge together to the appropriate row.
I’ve tried the concatenate node but that produces _dup row ids.
Please find the attached example
Many thanks

merge.knwf (15.4 KB)

[ipazin]

Hi there @jtamasi,

you should use Pivoting node. Just add additional column into table if you only have two columns. New column is then to be used as aggregation column.

Br,
Ivan

[HansS]

Hi @jtamasi,

As @ipazin mentioned. That is the way to go see this merge(2).knwf (39.6 KB)

gr. Hans

[jtamasi]

Thanks both of you for the quick answer and the solution