Problem joining four tables
Posted: Thu Dec 07, 2017 4:00 pm
New to DS. I am trying join 4 tables using the Join stage. The table structure are as follows
Tab_A
ID1 -->Key
xyz
TAB_B
ID1 --> Common Key for B & A
ID2 --> Common Key for B & C
ID3 --> Common Key for B & D
lmn
TAB_C
ID2 -->Key
pqr
TAB_D
ID3 -->
abc
In SQL we would join as follows
Select
*
from
TAB_A A, TAB_B B, TAB_C C, TAB_D D
where A.ID1= B.ID1
and B.ID2 = C.ID2
and B.ID3 = C.ID3
So Under properties of Join stage, I added 3 Repetitive Key as it is a 4 table join. I do not see any keys to chose from drop down to choose key for each one. So I manually type the column name to be used as Join key for each key.
But this throws following error when I run the job:
Join_XX: Error when checking operator: Key field "ID1" was not found in the view-adapted input schema
There are multiple errors like above for each key column.
Is there anything I am doing wrong?
Please let me know
Thanks
Tab_A
ID1 -->Key
xyz
TAB_B
ID1 --> Common Key for B & A
ID2 --> Common Key for B & C
ID3 --> Common Key for B & D
lmn
TAB_C
ID2 -->Key
pqr
TAB_D
ID3 -->
abc
In SQL we would join as follows
Select
*
from
TAB_A A, TAB_B B, TAB_C C, TAB_D D
where A.ID1= B.ID1
and B.ID2 = C.ID2
and B.ID3 = C.ID3
So Under properties of Join stage, I added 3 Repetitive Key as it is a 4 table join. I do not see any keys to chose from drop down to choose key for each one. So I manually type the column name to be used as Join key for each key.
But this throws following error when I run the job:
Join_XX: Error when checking operator: Key field "ID1" was not found in the view-adapted input schema
There are multiple errors like above for each key column.
Is there anything I am doing wrong?
Please let me know
Thanks