Forum Discussion

mgezzele's avatar
mgezzele
New Contributor
2 years ago

Transformation Rules

Hi All, 

 

i am presenting to you a situation to understand if what we are trying to do is feasible.

We are currently defining the transformation rules for a Client and these rules are quite complex, including composite logics (multi dimensional) and ranges and lists and masks. 

Based on our tentatives it seems that composite rules only accept masks as type of mapping apart from single code mapping. 

is there a way to use Ranges and Lists in composite mappings?

I.E. A#[40610047;40610099;40620001]:U5#[??1000????;??1001????;??1002????;??1003????;??1004????;??1005????;??1006????;??1007????;??1008????]

 

Thanks a lot

Marco

Data Integration
  • rjgoss's avatar
    rjgoss
    New Contributor III
    2 years ago

    Yes, you can use Range and Mask type mappings within composite mappings.  As for Lists, I haven't had a reason to try, so not sure, but it would be easy to find out, as long as you use the correct formatting.

    Composite with Range          F#1234~4567:U1#ABCD

    Composite with Mask (wildcards)          U2#1234??:E#Italy

    Composite with List          A#123;456;789:U3#17 (make sure to use semicolons)

    Good luck!