LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rbeliz000

I have a join node that is failing with the following
error ~~ unknown field for source": 'Type'

I have attached a copy of the error log for reference. I'm not sure what is causing this error. Any insight, would be greatly appreciated.

thanks,

R Beli

~~~~~Node Script~~~~~~~

Type = 1:Type
Type2 = 2:Type

if Type == "HSI/VID" then amt = 2
if Type == "HSI ONLY" or Type == "VID ONLY" then amt = 1

if Type2 == "HSI/VID" then amt2 = 2
if Type2 == "HSI ONLY" or Type2 == "VID ONLY" then amt2 = 1

ADD = amt2 - amt

Bucket = strcat(Type," to ",Type2)
month1_rev = 1:MONTH1_REV
month2_rev = 2:REVENUE_AMT
rev_diff = month2_rev - month1_rev


output 1 {
emit 1:*
where join.leftOrphan
}




output 2 {
emit 1:ACCOUNT_NUMBER
,1:REGION_NAME
,Bucket
,month1_rev
,1:MONTH1_REV_DATE
,month2_rev
,2:MONTH2_REV_EFF_DT
,rev_diff
,ADD
exclude referencedFields(2,{{^RightInputKey^}})
where join.match
and rev_diff <> 0
and ADD >= 1
and 1:region_name <> "MANAGED ENTITIES"
}




output 3 {
emit 2:*
where join.rightOrphan
}


~~~~End of Node Script~~~~~

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

The only reason I can see for this is if Input 1 or Input 2 does not contain the column "Type"

Type = 1:Type
Type2 = 2:Type

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: timonk

I concur with Stony. I did a quick test with a Join using your setup (stripped down a few fields, basically just using a field called Type, through 2 Static Data nodes). Your code works fine in my instance.

-Timon Koufopoulos
MDA Support.