Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
marishnagendran
Creator
Creator

Update the column

Dear All,

This is urgent requirement

CodePacking Size
  
MGMD00055 Litres
MFGD005050 Litres
MGMD0500500 Litres
MEGD005050 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

Labels (1)
1 Solution

Accepted Solutions
Lauri
Specialist
Specialist

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

View solution in original post

5 Replies
Lauri
Specialist
Specialist

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
Creator
Creator
Author

I want in data Load editor 

Lauri
Specialist
Specialist

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
Creator
Creator
Author

Thanks for your solution lauri

jesse6767
Contributor
Contributor

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.