Matrix data source, base ud5 column mapping on matrixed account

[TimVierhout]

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

[NicolasArgente]

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

[TimVierhout]

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

[NicolasArgente]

Thanks Tim, Feedback Appreciated 🙂