Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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 ;
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 ;