Lookup Function - Invalid Expression Error

[JustinM]

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 

[rwunderlich]

Is there something after the last FROM in your post?  And does that file contain DOReference?

[JustinM]

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

[rwunderlich · Accepted solution]

I think it should be "Collection Month"

Lookup('Collection Month','File Reference',DOReference,'RD Reports') as [Collection Month]