Need Help...

[#1]

Hi All,

PFA,

[MK_QSL]

[ASN Qty]-ApplyMap('Mapping', Material & Plant,if([Rwip Qty])<0 or ISNULL([Rwip Qty]),0) ) as Final_ASN_Qty

[MK_QSL]

Or change the mapping load table as

Mapping:

Mapping LOAD plant_Key,

  if([Rwip Qty]<0 or IsNull([Rwip Qty]),0,[Rwip Qty]) as [Rwip Qty] Resident RWIP_1;

[MK_QSL]

Please check enclosed file...

[#5]

Hi Manish,

In this case Mapping function only it takes 1st value comparing with duplicate values

EX:  ASN-RWIP=ASN_QTY_sample

10-20=-10

10-30=-20

10-80=-70

But, here consider only with -70

[MK_QSL]

Dear Sunil,

Mapping Load Table only take two columns/dimensions and also there should be no duplication in this table.

Otherwise, AppyMap function will take only the First Value.

Also, due to duplication in Mapping Load Table, ApplyMap will create duplicated rows...

[#7]

Hi Manish,

One more problem..

In my Plant_key last value 0606ABCA017

ASN QTY- Rwip Qty= Final_ASN_Qty

but here ASN_QTY value Null value(Null value should should be Zero her)

then 0-14=-14

NULL() values should be Zero in All columns

[MK_QSL]

Replace with this in your script...

IF(NOT ISNULL([ASN Qty]),if([ASN Qty]-ApplyMap('Mapping', Material & Plant)<0,0,[ASN Qty]-ApplyMap('Mapping', Material & Plant,0)),0) as Final_ASN_Qty

[#9]

Hi Manish,

How to calculate group by Plant_Key wise

sum(ASN_QTY -Sum(RWip_Qty) = Eff ASN

Eff_ASN i want to show group wise based on Plant_Key

PFA..

[#10]

please anyone can help me...........