Mapping/Joint

[solomonadjei]

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]);

[MK9885]

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

[solomonadjei]

Thanks for your respond Shahbaz,

I can I make it work ?

[Mark_Little]

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

[MK9885]

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]

[solomonadjei]

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

[solomonadjei]

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

[solomonadjei]

Thanks Mark.

It did work

[solomonadjei]

Thanks for your support Shahbaz,

It's working now