CompositeKey:
LOAD 
    AutoNumber(FieldA & '|' & FieldB) as Key,
    FieldA,
    FieldB
FROM SourceTable;

TableName:
LOAD Field1 as Alias1, Field2, Field1 * 1.1 as CalculatedField
FROM [lib://DataSource/Data.csv]
(txt, utf8, e...

CrossTable(Month, Sales, 1)
LOAD * FROM BudgetGrid.csv;

GENERIC LOAD ID, Attr, Val FROM Data.csv;

SalesSummary:
LOAD 
    Region,
    Sum(Amount) as TotalAmount
FROM SalesData.qvd
GROUP BY Region;

Hierarchy(NodeID, ParentID, Name, ...)
LOAD * FROM Nodes.csv;

StatusMapping:
LOAD * INLINE [
    StatusCode, StatusDescription
    1, Active
    2, Pending
    3, Inactive
    4, Clo...

IntervalMatch(EventDate)
LOAD Start, End FROM Periods.csv;

// Besser: ApplyMap verwenden
Map: MAPPING LOAD ID, Val FROM Dim.qvd;

LinkTable:
LOAD DISTINCT CustomerID, ProductID FROM Sales.qvd;
CONCATENATE (LinkTable)
LOAD DISTINCT CustomerID, Product...

UniqueCustomers:
LOAD DISTINCT
    CustomerID,
    Region
FROM [lib://Source/Orders.qvd] (qvd);

TableName:
LOAD Field1, Field2
FROM [lib://Path/File.csv]
(txt, codepage is 1252, embedded labels, delimiter is ';', msq...

LIB CONNECT TO 'ConnectionName';

TableName:
SQL SELECT Field1, Field2
FROM Schema.TableName
WHERE Condition;

TableName:
LOAD Field1, Field2
FROM [lib://Path/File.xlsx]
(ooxml, embedded labels, table is [Sheet1$]);

TableName:
LOAD *
FROM [lib://Path/File.qvd] (qvd);

TableName:
LOAD *
FROM Source
ORDER BY Field1, Field2 ASC;

TableName:
LOAD *
FROM [lib://Source/File.qvd] (qvd)
WHERE Condition;

CountryMap:
MAPPING LOAD CountryCode, CountryName FROM Countries.csv;

Customers:
LOAD
    CustomerID,
    Name,
    Cou...

MasterCalendar:
LOAD 
    Date($(vMin) + IterNo() - 1) as Date
AUTOGENERATE 1 
WHILE $(vMin) + IterNo() - 1 <= $(vMax...

// Breaks optimization — avoid for large QVDs
TableName:
LOAD SomeFunction(Field1) as Field1
FROM Data.qvd (qvd);

TableName:
LOAD Field1, Field2
FROM [lib://Path/File.qvd] (qvd);

QUALIFY *;
UNQUALIFY CustomerID;

Customers:
LOAD CustomerID, Name FROM Customers.csv;

RawData:
LOAD A, B FROM Source.csv;

TransformedData:
LOAD 
    A,
    B * 2 as CalculatedB
RESIDENT RawData;

DROP TABL...

// Single-line comment
/* Multi-line
   comment */

FactSales:
LOAD OrderID, CustomerID, ProductID, DateID, Amount FROM Sales.qvd;

DimCustomer:
LOAD CustomerID, CustomerNa...

Orders:
LOAD OrderID, Date FROM Orders.csv;

Shipments:
LOAD OrderID, Date as ShipDate FROM Shipments.csv;

Keys: LOAD DISTINCT ID FROM Source.csv;

Data:
LOAD *
FROM Large.qvd (qvd)
WHERE EXISTS(ID);