Skip to main content
T
TimVierhout
Newcomer
October 5, 2022

Matrix data source, base ud5 column mapping on matrixed account

  • October 5, 2022
  • 2 replies
  • 0 views

Hi all,

I have a matrix load, on which account is matrix. One column with a specific account needs to go to 2 different accounts. For this I just reference the same column twice. This works fine.

The issue is, the first instance the UD5 is coming from column 5, the second instance UD5 should come from column 16. How could I achieve this?

Thanks!

Tim

2 replies

N
NicolasArgente
Veteran
October 6, 2022

Hi Tim, Can you put some printscreen? I have the feeling that a Source Derivative rule could help... but not sure...

T
TimVierhoutAuthor
Newcomer
October 6, 2022

Hi Nicolas,

 

Thanks for the reply. I went the route of derivative rules first, but the transformation would become too complex for maintenance. Would be interesting to see if you can base a derivative rule on an attribute though, that probably would have done the trick.

 

In the end I had the bright idea to map both column 5 an 16 to the ud5 dimension, with an underscore in between.

In the transformation rules I used a composite rule with a complex expression to split the string and use the correct field to determine the ud5 member to use.

 

With kind regards,

 

Tim

    N
    NicolasArgente
    Veteran
    October 7, 2022

    Thanks Tim, Feedback Appreciated 🙂

     

    Terms & ConditionsAccessibility statement