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;
