Mapping table

[danny4202001]

Hello Friends,

I have a table coming with all items with standard prices,

Standard

ITEMS   PRICE

1              50

2              100

3               400

55           50000

 I want to keep standard price for items 3 and 55 and mapping price from below mapping CSV for items 1 & 2 as new price 

how do I do this?

Mapping table

ITEMS   PRICE

1              500

2              1000

Thanks,

D

[BrunPierre · Accepted solution]

PriceMapping:
Mapping LOAD * Inline[
ITEMS,PRICE
1,500
2,1000
];

Standard:
LOAD *,
ApplyMap('PriceMapping',ITEMS,PRICE) as [New Price] 
Inline[
ITEMS,PRICE
1,50
2,100
3,400
55,50000
];