Transform data in existing output module

Dear Community,

I have a case where I need to transform data based on product and customer information. The basic concept is that I have certain product # 1 and that value should be changed for certain customers.

I have started to investigate if I could have a system module where I specify that product and customers for the product what I want to see in the output module. This is not the optimum solution I know, but in the source data, this is impossible to implement.

My idea was that I can somehow lookup the desired product from the system module, but I got stuck because the system module doesn't have a line item that I want to use. My plan for a system module was that it works only for converting the list value on the output module.

Attached is an excel file where I have illustrated the case in more detail.

Lookup_Handling_99494.xlsx

Accepted answers

MarkWarren

I would do this with a line item in your first module, an override that looks up the mapping.
Something like this:

All comments

MarkWarren

I would do this with a line item in your first module, an override that looks up the mapping.
Something like this:

antti.kerola@elisa.fi

I got your point Mark, thanks for that.

I didn't implement to the output module. I implemented already the transformation in the data module so the output module is simple without extra logic.

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385