Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I'm trying to write an if condition, here A55 also includes A55.1,A55.2 and so on, I would like to include A89.91 and exclude A64.3, please advise
=if(Match(Left("Codes",3),
'A55',
'A56',
'A57','A58','A59','A60','A61','A62','A63','A64',
'A65',
),'yes','no')
=if(Match(Left('ABCD',3),
'A55',
'A56',
'A57','A58','A59','A60','A61','A62','A63','A64',
'A65','A89.91',
),'yes', if(Match(Left('ABCD',3),'A64.3'),'no'))
Hello @agigliotti , is this correct?
Hi @smanas ,
Maybe this:
=if(Match( Left(ABISCA,3),
'A55',
'A56',
'A57','A58','A59','A60','A61','A62','A63','A64',
'A65',
) and ABISCA <> 'A64.3',
'yes',
if( ABISCA = 'A89.91',
'yes','no'
)
)
I hope it can help.
Best Regards
map_codes:
Load * Inline [key, value
A55, yes
A56, yes
A57, yes
A58, yes
A59, yes
A60, yes
A61, yes
A62, yes
A63, yes
A64, yes
A65, yes
];
Load ApplyMap('map_codes', Subfield(Codes, '.', 1), 'no') as [flag column]
...
=if(Match(Left('ABCD',3),
'A55',
'A56',
'A57','A58','A59','A60','A61','A62','A63','A64',
'A65','A89.91',
),'yes', if(Match(Left('ABCD',3),'A64.3'),'no'))
Hello @agigliotti , is this correct?
Did you check my suggestion?
Hi @agigliotti it worked thanks a lot