How to Get data user prefered data?

debabrata_sahoo — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How to Get data user prefered data?

Gysbert_Wassenaar — Wed, 02 Jan 2019 14:27:04 GMT

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
    ;

topic How to Get data user prefered data? in QlikView

How to Get data user prefered data?

Re: How to Get data user prefered data?