Skip to main content
AndreaF
Expert
Jun 29, 2023 7:15 PM UTC
Solved

Source derivate transformation rule "missing operand" issue

Hi,

sorry, first time trying to use derivative transformation rules..

I have setup the following Derivative source transformation rule:

image.png

My understanding or derivative rule is that the account created by the rule (eg. New_CR and New_DR above) must then be mapped using the standard transformation rule, so I have done so:

image (1).png 

However, I get the following error when running a Load and transform of the data file:

image (2).png

What am I doing wrong? Thank you

NicolasArgenteAnswer
Veteran
Jun 30, 2023 7:27 AM UTC

Hi AndreaF !
I am with you on that one! I do not see the issue like this 🙂
Could you do checks and see what it does :
Change from A#[92??-*] to A#[92*] and run it. See if it runs.. 
I never tried a Derivative Rule with -, ?, * in the same syntax. That could be the issue. Not sure, but worth a try.

View in thread

3 replies

NicolasArgenteAnswer
Veteran
Jun 30, 2023 7:27 AM UTC

Hi AndreaF !
I am with you on that one! I do not see the issue like this 🙂
Could you do checks and see what it does :
Change from A#[92??-*] to A#[92*] and run it. See if it runs.. 
I never tried a Derivative Rule with -, ?, * in the same syntax. That could be the issue. Not sure, but worth a try.

AndreaFAuthor
Expert
Jun 30, 2023 12:32 PM UTC

That was it, using A#[92*] solved the issue. I have done some testing and it looks like the "?" character is what is causing the issue. It seems not to be allowed in derivative rules, even tough it can be used in Mask transformation rules.

    NicolasArgente
    Veteran
    Jun 30, 2023 12:36 PM UTC

    Thanks for the feedback AndreaF and good to see it is solved!

    Terms & ConditionsAccessibility statement