The columns F-V in table 2 are values also listed in table 1.
Columns A-E in table 2 should be integrated in table 1 so that A-E are used more than just one time according to the number of entries in the columns F-V.
How does it work?
Hi Lisa-Sophie,
You can use a Joiner node. Table 1 goes into the upper input port, Table 2 in the bottom port. Next, configure the Joiner node to use Left Outer Join on the columns which both tables have in common.
Cheers,
Roland