Update the column

[marishnagendran]

Dear All,

This is urgent requirement

Code	Packing Size
MGMD0005	5 Litres
MFGD0050	50 Litres
MGMD0500	500 Litres
MEGD0050	50 Litres

Based on Code I have create a logic for Packing size column

For Example Last Item code MEGD0050 Logic wise 50 Litres is correct. but Management people want as 5 litres

 Like this 16 codes has wrongly created in master.

I have one excel sheet 16 codes with Packing size.

for this 16 codes i want to update the packing size in table. Kindly help me

[Lauri]

Do you need to enter new values for PackingSize in the front end (which would require an extension), or can you add a Mapping table in the data load editor?

[marishnagendran]

I want in data Load editor 

[Lauri · Accepted solution]

You can add this as a mapping table to your data load editor, with all corrections:

CodeFix:
Mapping Load * Inline [
Code, New Size
MEGD0050, 5 litres
];

Then after that, apply it when you load your Excel file.

Data:
Load
Code,
"Packing Size" as "Old Size",
ApplyMap('CodeFix', Code) as "New Size"

From [excel file];

[marishnagendran]

Thanks for your solution lauri

[jesse6767]

Lenny’s Grill 

Lenny’s Grill is anticipating your visit constantly. To serve you better for your future visit, it is welcoming you to take the Lenny’s Subs Customer Satisfaction Survey to hear your feedback.