Populate cell to group of other cells

Hi,

I have one table PATHS and another PATHS_FINAL

PATHS
PATH1
PATH2
PATH3

and

PATHS FINAL

Group PATH
A PATH23
A PATH32
B PATH67
B PATH35
B PATH87
C PATH123
C PATH789

And I want to populate the table PATH inside each group of the Table PATHS_FINAL

Group PATH
A PATH23
A PATH32
A PATH1
A PATH2
A PATH3
B PATH67
B PATH35
B PATH87
B PATH1
B PATH2
B PATH3
C PATH123
C PATH789
C PATH1
C PATH2
C PATH3

How can I do that?

  1. Use Group by node to get unique group list from PATHS FINAL table.
  2. Use Cross Joiner with Groups table and PATHS table.
  3. Rename Group + Path table columns to be the same as in PATHS FINAL table.
  4. Append new Group + Path table to the PATHS FINAL by Concatenate node.