Modules with Different UID Dimensions

Isha

Hi ALL,

I have three input modules, each with different UID dimensions:

• Module A → Dimension: X_UID
• Module B → Dimension: Y_UID
• Module C → Dimension: Z_UID (also includes a dropdown line item with two options: Product X and Product Y)

Requirement:

• If a user selects Product X in Module C, the record should be stored in both Module C and Module A.
• If a user selects Product Y, the record should be stored in both Module C and Module B.
• The only common field across these three modules is Location.

Do I need to create a mapping module, LOOKUP, or another approach be the best practice to achieve this?

Please Advice!

Prajjwal88

Hi @Isha ,

If I’m understanding your problem correctly, where the source data module is Module C itself (though I’m not entirely sure what kind of data needs to be recorded—maybe a screenshot could help), here’s an approach you can consider:

Since the records will always be stored in Module C, you can:

1. Create a separate line item in Module C to store the data using an action with a non-blank filter.
2. For storing data into Module A and Module B, create mapping line items in Module C. These can be formulated using FINDITEM based on the concatenation of the selected Product/Product code (Whichever you're using for creation of list X_UID/Y_UID) in Module C and the corresponding UID which you can extract as you stated module C has dimension of Z_UID.
3. Then, create separate actions for pushing data into Module A and Module B based on these FINDITEM mappings (again using non-blank filters).
4. Finally, combine these actions into a single process so that everything runs with just one action button.

Hope this helps!