Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i am loading data from SQL and creating another table for some analytics and dropping. but after using QUALIFY - i am getting field not found error.
Ledgers:
QUALIFY LedgerLine;
Load
DocNum,
LedgerDate,
LedgerLine, etc..., from SQL
;
AllocLedgerTemp:
QUALIFY AllocLedgerLine;
Load
LedgerLine as AllocLedgerLine,
Module as AllocModule, etc...,
Resident Ledgers;
while loading the error,
Field not found error
Field 'LedgerLine' not found
Hi
once you quality the field get the table Name now the field name is Ledgers.LedgerLine
if want only this field to not be qualify you have to use
Qualify * ;
Unqualify LedgerLine;