topic Composite Key Issue with mapping Load in QlikView

Composite Key Issue with mapping Load

qlikviewwizard — Fri, 20 Nov 2020 18:02:30 GMT

Hi All,

I am facing mapping loading issue for the below script.

Please help to fix the issue.

MapCountry:

Mapping LOAD

[ID,Country

1,INDIA

2,Singapore

3,US

4,UK

5,Japan

];

Data:

LOAD *,

ApplyMap('MapCountry', ID) As Country,

ID & Name & Country As Key;

LOAD * inline [

ID,Name

1,A

2,B

3,C

4,D

5,E

6,F

7,G

8,H

9,I

10,J

];

EXIT Script;

Re: Composite Key Issue with mapping Load

jagan — Mon, 06 Jul 2015 07:24:06 GMT

HI,

Try this script

MapCountry:

Mapping LOAD

* INLINE // You missed this line

[ID,Country

1,INDIA

2,Singapore

3,US

4,UK

5,Japan

];

Data:

LOAD

ID & Name & Country As Key; // Moved this line to 3rd precedent load.

LOAD *,

ApplyMap('MapCountry', ID) As Country;

LOAD * inline [

ID,Name

1,A

2,B

3,C

4,D

5,E

6,F

7,G

8,H

9,I

10,J

];

Re: Composite Key Issue with mapping Load

MayilVahanan — Mon, 06 Jul 2015 07:25:12 GMT

Try like this

MapCountry:

Mapping LOAD * Inline

[

ID,Country

1,INDIA

2,Singapore

3,US

4,UK

5,Japan

];

Data:

LOAD *,

ID & Name & Country As Key;

LOAD *, ApplyMap('MapCountry', ID, 'N/A') As Country inline [

ID,Name

1,A

2,B

3,C

4,D

5,E

6,F

7,G

8,H

9,I

10,J

];

EXIT Script;

Re: Composite Key Issue with mapping Load

qlikviewwizard — Mon, 06 Jul 2015 07:30:14 GMT

Thank you so much jagan and MayilVahanan.

Re: Composite Key Issue with mapping Load

qlikviewwizard — Mon, 06 Jul 2015 07:31:12 GMT

Thank you jagan for correcting me where I was wrong.

Re: Composite Key Issue with mapping Load

tyagishaila — Mon, 06 Jul 2015 07:42:21 GMT

You can try it

Data:

LOAD *,

ID & Name & ApplyMap('MapCountry', ID) As Key;