Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
];
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
];