2. Merging Data Tables

<p>Nodes applied:</p><ul><li><p><strong>Table Creator</strong>: Created dummy datasets to use as examples (Data Table and Dictionary Table).</p></li><li><p><strong>Value Lookup</strong>: This function appends values from a dictionary table to a data table based on a matching column (like Store ID). You need a primary key (Store ID) to match the rows between the two tables, but the columns do not need to have identical headings (in this example, I used 'StoreID' and 'Store_ID'). This function essentially adds columns to the data table based on the matching values.</p></li><li><p><strong>Joiner</strong>: An inner join does not output the rows with non-matching Store ID values, and a full outer join outputs all rows, including the missing values. Checking the box for 'Split join result into multiple tables' in the Joiner node window will display the output ports containing the rows that do not match.</p></li></ul>