mapping n

[#1]

I have the following tabs in script:

tab1:

[Location list]:

LOAD [Department survey],

     Locations

FROM

[..\Data\EXCELs\Bilal-Mafraq locations.xlsx]

(ooxml, embedded labels, table is Locations);

Tab 2:

[Surveys]:

LOAD 1 as Count,

     Locations,

      [Q10.1. Please rate your overall experience with us:]as [Overall Experience],

FROM

[..\Data\EXCELs\Bilal-Mafraq inpatient (Feb mach).xlsx]

(ooxml, embedded labels, table is Sheet1);

Tab 3:

[Satisfaction Score]:

mapping LOAD * INLINE [

    Overall Satisfaction, Weight

    Satisfied, 100

    Extremely Satisfied, 100

    Neutral, 100

    Extremely Dissatisfied, 100

    Dissatisfied, 100

];

Tab 4:

[Surveys]:

Load

*,

ApplyMap('Satisfaction Score',[Overall Experience]) * Count as [Satisfaction Score];

When i Execute the code the table appear but the new mapping column (Satisfaction Score) doesnt appear.

Anybody have an idea what might be wrong? is it the order of the tabs or the apply mapping thing!!!!!!!

PLEASE HELP AS SOON AS POSSIBLE

[swuehl]

This seems to be an exact repost of your other thread.

Please try to avoid duplicating posts, it makes it hard to follow if answers are spread all over the forum.

Regards,

Stefan