Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Venkatesh11789
Contributor
Contributor

Field not found error

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

Labels (2)
1 Reply
srchagas
Creator III
Creator III

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;