Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
the syntax of the following expression in the script seems correct or no?
If(ApplyMap('KEY_TO_DISCIPLINA',[@10:17],'n/a')='35','ODONTO',
If([@4:9]='001880','DIALISI',
If(Match(ApplyMap('KEY_TO_NOTA',ApplyMap('DOUBLE_MAPPING',[@10:17],'n/a')),'IHca','MIHca'),'BOCA',
If(WildMatch(ApplyMap('KEY_TO_BS_STS21',ApplyMap('DOUBLE_MAPPING',[@10:17],'n/a')),'008'), If([@4:9]=030357,'PS_RADIO','RADIO'),
If(WildMatch(ApplyMap('KEY_TO_BS_STS21',ApplyMap('DOUBLE_MAPPING',[@10:17],'n/a')),'011'), If([@4:9]=030357,'PS_LAB','LAB'),
If(WildMatch(ApplyMap('KEY_TO_NOTA',ApplyMap('DOUBLE_MAPPING',[@10:17],'n/a')),'Ihmac'),'MAC',
If(Len(Trim([@10:17]))>0, If([@4:9]=030357,'PS_AMB','AMB')))))))) as TIPO
I ask this question because the sw don't show me some values (e.g. "PS_LAB", "PS_RADIO") and i don't know why.
In this records, the sw show me PS_AMB instead e.g. PS_LAB
Attached is a sample data file where the expression is the same (or no)?
Please, someone can help me?
Thanks,
Mattia
ps: There is no attachment placed.
Hi Arthur,
please, see this open thread with all the sources:
Thanks,
Mattia