topic Re: Mapping load problem in QlikView

Mapping load problem

Fri, 20 Nov 2020 18:02:30 GMT

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

Re: Mapping load problem

qlikmsg4u — Thu, 20 Aug 2015 06:32:32 GMT

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

];

Re: Mapping load problem

jonathandienst — Thu, 20 Aug 2015 06:36:18 GMT

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.

Re: Mapping load problem

tyagishaila — Thu, 20 Aug 2015 06:37:30 GMT

You have to use join instead of ApplyMap.