ListJoiner Help

image

Introduction

ListJoiner is an application that can quickly and easily combine/join records from two lists.

To import data into ListJoiner the data must be in the CSV-file format. CSV stands for „Comma-separated values“.

A „join“ is a means for combining fields from two lists by using values common to each. For example if there are two lists and both lists have a column named „Order ID“ (see image below).

You can join the two lists by specifying the number of the column that is common to each list.


listjoiner_ui_1

Using ListJoiner

To import data files into ListJoiner push the „Select file“-buttons on the left an then on the right (see image below).

listjoiner_ui_import

After pushing a „Select file“-button and selectiong a CSV-file you can set the import options (see the red numbers in the image below).

  1. You can choose the delimiter and character encoding used in the CSV-file.
  2. ListJoiner shows a preview of the data in the CSV-file (the first 20 rows of data). If the data is not displayed correctly, probably the selected delimiter or the selected character encoding is wrong (or both). You can try to change the delimiter and character encoding until the preview shows the data correctly.
  3. Press the „Import file“-button if you are ready to import the CSV-file into ListJoiner.

listjoiner_ui_import

Both imported lists in the image below have a column named „Order ID“. In order to join the lists based on the common values in these columns we enter the number of the columns into the corresponding textfields (see image below). Press the „Join lists“-button to show the join-options.

llistjoiner_ui_columns.png

ListJoiner supports two different ways to combine two lists:

  1. Inner join: Select 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 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 join returns all records from list 1 and any matching records from list 2.

listjoiner_ui_2

After joining the two lists the result is displayed in the bottom half of the window (see image below). You can save the result by pressing the „Export“-button.

listjoiner_ui_1

You can export the joined list to a CSV-file which you can later open/edit in a spreadsheet application. If the exported data is not recognized correctly by your spreadsheet application, you can try to change the export options (see image below). You can choose a different delimiter and/or a different character encoding. Also selecting „Quote all fields“ can sometimes increase compatibility.

listjoiner_ui_3




ListJoiner 1.0
Copyright © 2020 Christian Mézes
Web: https://cmezes.com
Email: support@cmezes.com

Thank you for choosing ListJoiner and supporting us!

If you find any bugs or if you have suggestions for new features please feel free to contact us.