Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I'm trying to add a column from my first table (Rd Reports) to my 2nd table (RD Data) but keep getting an invalid expression error. Am I doing something obviously wrong in the formula or do I need to check somewhere specific to fix it?
Any help appreciated
for each Rdfile in filelist(xx)
[RD Reports]:
LOAD
Amount,
"File Reference" as [File Reference],
"Month"as "Collection Month",
FROM [$(Rdfile)]
(ooxml, embedded labels);
next Rdfile
[RD Data]:
LOAD
DOReference as [File Reference],
Lookup('Month','File Reference',DOReference,'RD Reports') as [Collection Month]
FROM
I think it should be "Collection Month"
Lookup('Collection Month','File Reference',DOReference,'RD Reports') as [Collection Month]
Is there something after the last FROM in your post? And does that file contain DOReference?
Hi
Yes, the file location and then just the rest of the script (Tag fields and auto calendar).
Yes, the file does have the DOReference in.
Thanks
I think it should be "Collection Month"
Lookup('Collection Month','File Reference',DOReference,'RD Reports') as [Collection Month]