Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to using match function in the following expression, please suggest the correct way of using it. I using the following but there is error in expression in drill down group.
IF([CountryRegion.Region]='China','China'
IF([CountryRegion.Region]='Norway','Norway'
If(Match([CountryRegion.Region]='Sweden', 'Denmark' , 'Finland','EU'
IF([CountryRegion.Region]='France','France' ))))
Thank you
IF([CountryRegion.Region]='China','China',
IF([CountryRegion.Region]='Norway','Norway',
If(Match([CountryRegion.Region],'Sweden', 'Denmark' , 'Finland'),'EU',
IF([CountryRegion.Region]='France','France' ))))
if your requirement is to replace the existing value of a field with a new value then you can manage that at script level by using mapping load and applymap function.
Create a map table using mapping load that will have two fields From, To.
and then call applymap function by passing the current value and get the new values as a new field.
Try these ways
IF([CountryRegion.Region]='China','China',
IF([CountryRegion.Region]='Norway','Norway',
If( Match ( [CountryRegion.Region],'Sweden', 'Denmark') , 'Finland',
IF([CountryRegion.Region]='France','France','EU'))))
Try this....
IF([CountryRegion.Region]='China','China'
IF([CountryRegion.Region]='Norway','Norway'
If(Match([CountryRegion.Region]='Sweden', 'Denmark' , 'Finland'),'EU'
IF([CountryRegion.Region]='France','France' )))
IF([CountryRegion.Region]='China','China',
IF([CountryRegion.Region]='Norway','Norway',
If(Match([CountryRegion.Region],'Sweden', 'Denmark' , 'Finland'),'EU',
IF([CountryRegion.Region]='France','France' ))))
if your requirement is to replace the existing value of a field with a new value then you can manage that at script level by using mapping load and applymap function.
Create a map table using mapping load that will have two fields From, To.
and then call applymap function by passing the current value and get the new values as a new field.
Earlier was typo and saved try this one
IF([CountryRegion.Region]='China','China',
IF([CountryRegion.Region]='Norway','Norway',
If( Match ( [CountryRegion.Region],'Sweden', 'Denmark','EU') = 1, 'Finland',
IF([CountryRegion.Region]='France','France'))))