12 joining tables – Wasp Barcode WaspLabeler +2D User Manual User Manual

Page 172

Advertising
background image

168

Wasp Labeler User Manual

4.12 Joining Tables

After selecting a data source on the Data Source tab, one or more tables (or spreadsheets) can be
selected for use with the label you are designing. While you can't select more than one data source at
a time for your label, you can select more than one table within a single data source. In order to use
data from more than one table, you will need to join the tables by creating a link between them. To join
tables you will link two columns with common data, then select which columns from each table you
want to include on your label.

Example - When to Use the Join Tables Function

Joining tables is useful if, for example, you are creating an employee badge
and want to include the employee and department. You might have two
spreadsheets, one containing the employee name and department ID code
and another containing department ID codes and the corresponding
department name. You can combine the two tables by creating a link
between the department ID code column in the first spreadsheet with the
department ID code in the second spreadsheet. Then you can select to
include only the employee name from the first table and department name
from the second table on your labels.


Advertising