Hello,
I'm trying a Derivative Rule where I've one source target account which needs to be mapped to an another account and combination of attributes, the idea is it should create new row for each account attribute, but as I'm using multiple attribute values at once it throwing me an error Please let me know what I'm missing out or what I'm doing wrong from the below expression.
A#[56000]=[ABC]:A1#[ACC-*;FTM-*;BTSRR-*;BPR-*;BSC*;CON-*]
This solution is for source derivative rule :
You will need to map the A1 portion of it to a target A1 : For example A1#[ A;B;C] = ABC_NEW and then when you do a TR , map the account and A1 combo to the target account where you want it to go. Hope this helps
The above is the case if you want this account and A1 combos to go to a single target account .
If you want 56000 and A1[ACC-*] To go to a single target you need to have separate lines as below :
A#[56000] = ABC:A1[ACC-*] = ABC
A#[56000] = XYZ:A1[ACC-*] = XYZ
and then use TR (TRANSFORMATION RULE ) to map to the correct account using the account and A1 combo .
As the target values are unknown and might change or get some new values ahead of it we cannot assign it to a specific target value. We need the expression to be dynamic so that it will be able create new rows for the attributes mentioned.
If i add multiple values i get the following error message:
Error in Like operator: the string pattern 'ACC-*;FTM-*' is invalid.
I tried adding single rows for each attribute value and it is working fine, but still need a way to accomodate it in a single expression. Also trying another approach with the help of complex expression.
Have you tried this :
A#[56000]=ABC:A1#[ACC*;FTM*;BTSRR*;BPR*;BSC*;CON*]= ABC
