ListJoiner

ListJoiner is an application that can quickly and easily combine/join records from two lists or show the differences between two lists (for example, which entries are in list 1 but not in list 2).

To import data into ListJoiner the data must be in the CSV-file format.

ListJoiner supports six different ways to combine/diff two lists:

• LEFT OUTER JOIN: Select all records from list 1, along with records from list 2 for which the join condition is met (if at all). A LEFT OUTER JOIN returns all records from list 1 and any matching records from list 2.
• RIGHT OUTER JOIN: Select all records from list 2, along with records from list 1 for which the join condition is met (if at all). A RIGHT OUTER JOIN returns all records from list 2 and any matching records from list 1.
• FULL OUTER JOIN: Is the combination of a LEFT JOIN and a RIGHT JOIN. It includes all records from the joined tables whether or not the other table has the matching record.
• NON-MATCHING ITEMS (LIST 1): Selects all items that are present only list 1, but not in list 2.
• NON-MATCHING ITEMS (LIST 2): Selects all items that are present only list 2, but not in list 1.

You can export the joined list to a CSV- oder Excel file which you can later open/edit with a spreadsheet application.