
Contributor
2023-06-02
05:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
461 Views
1 Reply

Creator III
2023-06-02
05:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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;
445 Views
