Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a mapping load table which has two column ,Primary key and a column,
Second table where i apply map ,where in have two column ,Primary Key and a field
In mapping load table i have 15 records , and in Second table that is apply map table i have 10 records
So when i Run the script , in output table i get only 10 records which r in apply map table
How to show the missing value of Mapping load table?
For Example:
Customer:
Mapping Load * inline
[
CustId,Name
1,a
2,b
3,c
4,d
5,e
6,f
7,g
8,h
9,i
10,j
13,hkjk
];
Conmpany:
LOAD *,
ApplyMap('Customer', CustId,'unknown') as Name;
LOAD * Inline
[
CustId,Country
1,qw
2,ewrrs
3,gdfghdf
4,dfghdh
5,b
6,h
7,hd
8,h
9,gh
10,gh
];
when you run the above script the value CustId=13 will be missing
How to show the Primary Keys of mapping load table in apply mapping table even though they are missing
Use left join instead of Applymap.
Customer:
Load * inline
[
CustId,Name
1,a
2,b
3,c
4,d
5,e
6,f
7,g
8,h
9,i
10,j
13,hkjk
];
Left Join
Conmpany:
LOAD * Inline
[
CustId,Country
1,qw
2,ewrrs
3,gdfghdf
4,dfghdh
5,b
6,h
7,hd
8,h
9,gh
10,gh
];
Load the table normally and then create a separate mapping table:
CustomerList:
Load * inline
[
CustId,Name
1,a
2,b
...
13,hkjk
];
Customer:
Mapping LOAD * Resident CustomerList;
...
Customer 13 / hkjk will exist after the load is complete, but will not be linked to any facts.
You have to use join instead of ApplyMap.