Resident table syntax when loading from excel files

[isciberras]

Hi Everyone,

I'm having trouble using resident tables to reference a field from a previously loaded table.

Basically, from one tab I'm loading in the following data:

Table1:

Load Order_Ref,

          InvoiceDate

From

From another tab I'm loading:

Left keep

LOAD [InvoiceDate] Resident Table1

Load Order_Ref,

          PurchaseOrderDate,

          InvoiceDate - PurchaseOrderDate as [dif]

From

The issue I'm facing is that I get an error saying it cant find InvoiceDate which would have been loaded from a previous table. Any ideas on what I could do to get this to work?

Thanks,

Isaac

[isciberras]

I have been trying to fix this issue for 2 days and this code worked. I can't thank you enough! I appreciate your help very much