Merging two tables together


Consider two tables

a b c d
1 3 4 5

b d
5 6

how do I merge the second table into the first one resulting in

a b c d
1 5 4 6

In reality I have around 130 columns to merge, so doing it column by column with the column merger node is not an option

Thx for your help

Hello @fschmid,

use Unpivoting on both tables followed by Joiner based on RowIDs and ColumnNames columns so you can use Merger only once. Finish it with Pivoting to get proper table format :wink:



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