10-05-2022 02:20 PM
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
10-06-2022 08:48 AM
Hi Tim, Can you put some printscreen? I have the feeling that a Source Derivative rule could help... but not sure...
10-06-2022 03:25 PM
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
10-07-2022 05:23 AM
Thanks Tim, Feedback Appreciated 🙂