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).
ListJoiner supports 6 different ways to combine/diff two lists:
1. INNER JOIN: Selects all records from list 1 and list 2, where the join condition is met. An inner join returns records at the intersection of the two lists.
2. LEFT OUTER JOIN: Selects all records from list 1, along with records from list 2 for which the join condition is met (if at all). A left join returns all records from list 1 and any matching records from list 2.
3. RIGHT OUTER JOIN: Selects all records from list 2, along with records from list 1 for which the join condition is met (if at all). A left join returns all records from list 2 and any matching records from list 1.
4. 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.
5. NON-MATCHING ITEMS (LIST 1): Selects all items that are present only list 1, but not in list 2.
6. NON-MATCHING ITEMS (LIST 2): Selects all items that are present only list 2, but not in list 1.
To combine two lists or to find out the differences between them, both lists must have a column where common values are used. For example, if there is a column named "Order ID" in both lists.
To be able to import a file into ListJoiner, the file must be in CSV format.
You can export the joined list to a CSV- or Excel-file which you can later open/edit with a spreadsheet application.
