Script Error-fields not found

[#1]

Hello,

Below is my newly added script. I get an error where it says field not found for <ENCTR ID>, <DiagKey>, and <ProcKey>. Its as if it is not recognizing the aliases I put in. Does anyone know how to fix this? Attached is the full script.

Thanks,

EK

//***********************SEC_DIAG**********************************
OUTER JOIN(20112012)
LOAD [ENCOUNTER ID] as [ENCTR ID],
[SEC DIAG ORDER INDEX],
[SEC DIAG & NAME],
[SEC POA],
AutoNumberHash128([ENCTR ID], [SEC DIAG ORDER INDEX], [SEC DIAG & NAME], [SEC POA]) AS DiagKey
FROM
[SEC DIAG 1 week.xls]
(biff, embedded labels, table is Sheet1$);

Diagnosis:
LOAD
DiagKey,
[PRIN DIAG] AS Diagnosis
Resident 20112012;

LOAD
DiagKey,
[SEC DIAG & NAME] AS Diagnosis
Resident 20112012;

//***********************SEC_PROC**********************************
OUTER JOIN(20112012)
LOAD [ENCOUNTER ID] as [ENCTR ID],
[SEC PROC ORDER INDEX],
[SEC PROC ICD9 & NAME],
[SEC PROC HCPC & NAME],
num([SEC PROC ORDERING PRACT], '000000') AS [SEC PROC ORDERING PRACT],
[SEC PROC SERVICE DATE],
AutoNumberHash128([ENCTR ID], [SEC PROC ORDER INDEX], [SEC PROC ICD9 & NAME], [SEC PROC HCPC & NAME], [SEC PROC ORDERING PRACT], [SEC PROC SERVICE DATE]) AS ProcKey
FROM
[SEC PROC 1 week.xls]
(biff, embedded labels, table is Sheet1$);

ProcedureInpatient:
LOAD
ProcKey,
[PRIN PROC] AS ProcedureInpatient
Resident 20112012;

LOAD
ProcKey,
[SEC PROC ICD9 & NAME] AS ProcedureInpatient
Resident 20112012;

ProcedureOutpatient:
LOAD
ProcKey,
[PRIN PROC] AS ProcedureOutpatient
Resident 20112012;

LOAD
ProcKey,
[SEC PROC HCPC & NAME] AS ProcedureOutpatient
Resident 20112012;

[alexandros17 · Accepted solution]

When you use autonumberhash fields are the original not aliases

hope it helps