cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Match Expression stored in a Variable

TLOY_TGA
New Contributor

I have a Pipeline using in different branches the same Mapper for one of the Field
See ScreenShot
image

I would like to use a Pipeline Variable in my Mapping Expression in order to update/maintain only once my expression

my ORGANISATION Mapping expression looks like this

{match $ORGANISATION {
โ€œH10โ€ => โ€œCC_0001โ€,
โ€œH11โ€ => โ€œCC_0004โ€,
โ€œH12โ€ => โ€œCC_0004โ€,
โ€œH1000โ€ => โ€œCC_0001โ€,
โ€œH1100โ€ => โ€œCC_0002โ€,
โ€ฆ

โ€œโ€ => โ€œCC_ERRORโ€,
_ => $ORGANISATION}}

How is this possible?

Thank you for your answer

6 REPLIES 6

Thanks for the example Del - I was thinking of this differently. Agree that eval would work - but performance would be seriously impacted.

TLOY_TGA
New Contributor

Thank you guys, I will make a test in the coming week and let you know