The 'Unqualify' Regular Statement

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

This statement is used to remove the qualify statement previously used from fields. This is useful for leaving key fields identically named within the data model. The statement will apply to subsequently loaded fields only.

Statement syntax

Copy code


Unqualify fieldlist;

Fieldlist

A comma separated list of fields to be unqualified going forward.

Example

Two tables are loaded and all fields are qualified. The ‘id’ field is unqualified so that the tables can be associated using it.

Copy code


Qualify *;
Unqualify id;
ITEMS:
LOAD
    id,
    cost,
    "type",
    flavour
FROM [lib://Public:DataFiles/item_details.xlsx]
(ooxml, embedded labels, table is Sheet1);
ORDERS:
LOAD
    orderId,
    itemId as id
FROM [lib://Public:DataFiles/order_items.xlsx]
(ooxml, embedded labels, table is Sheet1);