How to Get data user prefered data?

[debabrata_sahoo]

Hello everyone, Please help me in below requirement . How i will do it in join.  After join with preceding load or resident load its is possible but here i need with out it.

SOURCE

Table1
C_Code
1
2
3
4
5
6
7
8
9

Table2
C_Code	C_Group
1	A
2	B
3	C
4	A
5	C

output

OutputTable
C_Code	C_Group
1	A
2	B
3	C
4	A
5	C
6	A
7	A
8	A
9	A

[Gysbert_Wassenaar · Accepted solution]

Perhaps like this:

mapCode2Group:
MAPPING LOAD 
    C_Code, C_Group
FROM
    SourceTable2
    ;

Output:
LOAD
    C_Code,
    ApplyMap('mapCode2Group',C_Code, 'A') as C_Group
FROM
    SourceTable1
    ;