Apply Map

[bharatkishore]

Hi All,

I have 2 tables one table is like

T1:

LOAD Modality,

     Material_Code as  [System Code],

     PartType as  [Norm group],

     PLANT

FROM

(qvd);

and second table is like

T2:

LOAD Modality,

     [Product Group],

     [System Code],

     [Norm group],

     Global_Norm,

     CN_Norm,

     RUID_Norm

FROM

(qvd);

Now in first qvd i have plant and in that plant i have CN93, ID93 ,Global, RU93 data.

Now in second qvd i have CN_Norm, RUID_Norm and Global.

Now based on first field plant when it is CN93 i should get sum(CN_Norm) and when it is RU93 i should get sum(RUID_Norm ) and when it is Globali should get sum(Global) .

Can you please help me how can i acheive it.

Do i need to use apply map or any other.

Attached app for more reference.

Thanks,

Bharat

[sasiparupudi1]

T1:

LOAD

Modality,

Material_Code as  [System Code],

ApplyMap('Map_Amount',PLANT,0) As Amount,

PartType as  [Norm group],

PLANT

FROM

(qvd);

[bharatkishore]

I will try to explain bit clearly.

In Table1 i have

Modality,

    Material_Code a

    PartType

    PLANT

and in plant i have CN93, RU93 and Global

and in Table 2 in have CN_Norm,Global and RU_Norm.

Now in final  table i need to get

Modality ,Material_Code ,    PartType,  CN_Norm,Global and RU_Norm

Now from first qvd if plant is CN93 it should take CN_Norm from second table and if plant is RU93 it should take RU_Norm from second table, and last if plant is not CN_Norm and RU_Norm then it should take Global.

Final T3 should be containing these fields

   Modality ,Material_Code ,    PartType(from first table ),  and  CN_Norm,Global and RU_Norm which we derive based on condition from second table.

Sorry for confusion.

Hope this is better

[bharatkishore]

Hi Sunny,

Anything you needed...

Please let me know