Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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];
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?
I want in data Load editor
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];
Thanks for your solution lauri
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.