Trouble loading data

khadijaceesay — Thu, 21 Sep 2023 14:34:45 GMT

Hi everyone,

I'm having some trouble referencing data I previously loaded in the data load editor. I loaded an excel file as a dataset and I'm attempting to pull that data into another app in the same space. I used the script below to load the data in and use an If statement against that data but I'm receiving this error "Field 'CurrentPOs' not found." Any thoughts?

LOAD
[Current POs] as [CurrentPOs]
FROM [lib://Hopewell Self Service Analytics:DataFiles/Hopewell AO PO.xlsx]
(ooxml, embedded labels, table is Sheet1);

Load
if(ParentWONo=[CurrentPOs],'AO', 'Not AO')as AO?
resident F0911_AccountLedger_temp2;
drop table F0911_AccountLedger_temp2;

Re: Trouble loading data

anat — Thu, 21 Sep 2023 20:23:05 GMT

seems ParentWONo and [CurrentPOs] columns are coming from 2 different source tables.

can you place your complete script here....

topic Trouble loading data in Qlik Automate

Trouble loading data

Re: Trouble loading data