ListJoiner at Mac App Store analyse

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.