Forum Discussion

jeffvdt's avatar
jeffvdt
New Contributor II
4 months ago

transformation rules - composite rule expression

Hi All,

We have a requirement with regard to our data mapping. There are certain data fields which are marked as XXXXX. We want to skip these by using for example X? and X* but that does not seem to work.

How can we simply skip every value which starts with and X?

Thanks in advance.

Data Integration
Transformation
  • SimonHesford's avatar
    SimonHesford
    Contributor
    4 months ago

    That will work as long as the Target is set to Bypass and there are no other rules which catches a source value beginning with X which execute before your Mask transformation rule

     

  • CarlosAlvear's avatar
    CarlosAlvear
    Contributor
    4 months ago

    to complement, you have to set in the target dimension as (Bypass) [including round parenthesis].

    Regards