The ‘Qualify’ Regular Statement

This article will cover the syntax of the ‘Qualify’ regular script statement. 

Using this statement adds a prefix matching the table name to the fields specified.

Statement syntax

Copy code 


Qualify fieldlist;
FieldlistA comma separated list of fields that should have the table name added as a prefix. Wildcards can be used here.

Example

In this example, a data table is loaded and the table name ‘CUSTOMERS’ is added as a prefix to the fields.

Copy code 


Qualify *;
CUSTOMERS:
LOAD
    id,
    firstName,
    lastName,
    email,
    dob
FROM [lib://Public:DataFiles/customers.xlsx]
(ooxml, embedded labels, table is Sheet1);

Result

All fields loaded have a prefix of ‘CUSTOMERS’.