Mapping table

danny4202001 — Wed, 19 Mar 2025 23:06:21 GMT

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,

Re: Mapping table

BrunPierre — Thu, 10 Nov 2022 20:43:04 GMT

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 ];

topic Re: Mapping table in Data Movement & Streaming

Mapping table

Re: Mapping table