Field not found error

[Venkatesh11789]

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

[srchagas]

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;