topic Re: Mapping/Joint in QlikView

Mapping/Joint

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

Hello Experts,

Am trying to map the following table to my existing app but it’s not doing what am looking for. could someone please help me on this?

The stp: table has loaded fine, however, its not making any joint to the my trust: table. both doing seperate things.

Many Thanks

stp:

Mapping LOAD [Trust Name],

Name

FROM

[..\..\DAT_FileData\NHS Supply Chain\STP.xlsx]

(ooxml, embedded labels, table is [EoE Members]);

trust:

LOAD [Trust code],

[Trust Name],

Type,

[Type of Member],

[Annonymised Trust],

[Available on TR reports],

Comments,

ApplyMap('stp',[Trust Name]) as [KEY [Trust Name]

FROM

[..\..\DAT_FileData\NHS Supply Chain\Trust_Codes.xlsx]

(ooxml, embedded labels, table is [EoE Members]);

Re: Mapping/Joint

MK9885 — Wed, 24 Oct 2018 15:51:33 GMT

You are linking your mapping table?

stp table would not link to your trust table

stp table is a mapping load.. to put it simpler, stp would disappear after you use your apply map function.

Its just used to change names of the values in your [Trust Name] dimension

Re: Mapping/Joint

solomonadjei — Wed, 24 Oct 2018 15:56:27 GMT

Thanks for your respond Shahbaz,

I can I make it work ?

Re: Mapping/Joint

Mark_Little — Wed, 24 Oct 2018 16:07:37 GMT

Hi Solomon,

The syntax of your mapping should be ok.

Although field alias might be off.

ApplyMap('stp',[Trust Name]) as [KEY [Trust Name],, would advise [KEY Trust Name].

You should have the name values in the [KEY Trust Name] field.

If this is blank then the mapping is failing due to Trust name not matching between the Map and Trust table.

This can be proven by adding the below to your apply map.

ApplyMap('stp',[Trust Name],'Map Failed') as [KEY Trust Name]

Mark

Re: Mapping/Joint

MK9885 — Wed, 24 Oct 2018 16:09:20 GMT

sorry I did not understand you question...

As I said stp table is a mapping load I.E a TEMP Table which will not be available in your data model.

If you want to link these tables just do

stp:

LOAD [Trust Name],

Name

FROM

[..\..\DAT_FileData\NHS Supply Chain\STP.xlsx]

(ooxml, embedded labels, table is [EoE Members]);

trust:

LOAD [Trust code],

[Trust Name],

Type,

[Type of Member],

[Annonymised Trust],

[Available on TR reports],

Comments

FROM

[..\..\DAT_FileData\NHS Supply Chain\Trust_Codes.xlsx]

(ooxml, embedded labels, table is [EoE Members]);

The tables would be linked now based on [Trust Name]

Re: Mapping/Joint

solomonadjei — Wed, 24 Oct 2018 16:26:05 GMT

Thanks Mark, I will give it a go and update your on this.

Re: Mapping/Joint

solomonadjei — Wed, 24 Oct 2018 16:32:55 GMT

Thanks Shahbaz.

I know this is an alternative way to join but I wanted to use a Mapping/ApplyMap table .

I will send the table so you have clear idea of what I mean and want to do.

Thanks ones again

Re: Mapping/Joint

solomonadjei — Thu, 25 Oct 2018 12:47:05 GMT

Thanks Mark.

It did work

Re: Mapping/Joint

solomonadjei — Thu, 25 Oct 2018 12:48:19 GMT

Thanks for your support Shahbaz,

It's working now