Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm working on integrating the following to my existing script however I am getting an 'Invalid Expression' error when loading the data, any ideas why? 😬
If(Match(Concat(POL_MAIN_BUSINESS_ZONE,POD_MAIN_BUSINESS_ZONE),
'MID EAST-IND CONFAR EAST',
'MID EAST-IND CONMID EAST-IND CON',
'FAR EASTFAR EAST',
'MID EAST-IND CONFAR EAST'),
'Out of Scope',
'Within Scope') as Scope
In addition to this code i would like to add an exception to this, that is, if within the POL_MAIN_BUSINESS_ZONE or POD_MAIN_BUSINESS_ZONE = FAR EAST and that POL_COUNTRY or POD COUNTRY = TIMOR then it should be flagged as Within Scope otherwise Out of Scope.
Maybe try this:
If(Match(POL_MAIN_BUSINESS_ZONE&' '&POD_MAIN_BUSINESS_ZONE,
'MID EAST-IND CONFAR EAST',
'MID EAST-IND CONMID EAST-IND CON',
'FAR EASTFAR EAST',
'MID EAST-IND CONFAR EAST'),
'Out of Scope',
'Within Scope') as Scope
Maybe try this:
If(Match(POL_MAIN_BUSINESS_ZONE&' '&POD_MAIN_BUSINESS_ZONE,
'MID EAST-IND CONFAR EAST',
'MID EAST-IND CONMID EAST-IND CON',
'FAR EASTFAR EAST',
'MID EAST-IND CONFAR EAST'),
'Out of Scope',
'Within Scope') as Scope
Nice one Arthur, thanks for that. 🙂