Apply map issue

[bharatkishore]

Hi All, i have the below code:

Category:

LOAD (Modality) as Key,

     Consumption

FROM

[..\\Period_Level1_1.qvd]

(qvd);

Final_Category:

Mapping

Load Key,

Consumption

Resident Category;

Drop table Category;

Overview:

LOAD (Modality) as Key

     IB

FROM

[..\sum.qvd]

(qvd) where  match(Modality,'AMI','CT','MR','US','DXR','IXR');

Final_Overview:

LOAD Key,

  IB,

     ApplyMap('Final_Category',Key,'') as Consumption

     Resident Overview;

     DROP Table Overview;

After reloading my consumption value is becoming 4 times higher.

Can you please tell me where i am missing.

Thanks,

Bharat

[shansundar]

Script looks correct, please upload sample qvw file with data we can try and let you know.

Thanks,

Shan S

[bharatkishore]

Thanks SS.

Issue is in the data side.. figured it out.. If anything else is there will keep you posted.

Thanks again..