Mapping load problem

[#1]

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

[qlikmsg4u]

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

];

[jonathandienst]

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.

[tyagishaila]

You have to use join instead of ApplyMap.