Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hiiiiiii
is this wild match script correct if not then help me in this .
=if(WildMatch([ICD_CODE_LEVEL1_org],('T02.9','T02.8','T02.7','T02.6','T02.5','T02.4','T02.3','S43.3','S43.2','S43.1','S43.0','S42.9','S42.8','S42.7','S42.4','S42.3','S42.2','S42.1',
'S42.0','S62.8','S62.7','S62.6','S62.5','S62.4','S62.3','S62.2','S62.1','S62.0','S22.8','S22.5','S55.9','S55.8','S55.7','S55.1','S55.0','S32.7','S32.5','S32.4','S32.3','S32.2','S32.1',
'S32.0','S52.4','S52.3','S52.2','S52.1','S52.0','S93.2','S92.9','S92.7','S92.5','S92.4','S92.3','S92.2','S92.1','S92.0','S02.9','S02.8','S02.7','S02.6','S02.5','S02.4','S02.3','S02.2',
'S02.1','S34.1','T93.2','T90.2','T90.0','B97.3','S65.2','S65.0','S45.1','S45.0','S44.8','S44.7','S44.4','S44.3','S44.2','S44.1','S44.0','S82.7','S82.6','S82.5','S82.4','S82.3','S82.2',
'S82.1','S82.0','T93.1','T92.9','T92.8','T92.5','T92.4','T92.3','S59.7','A18.0','S64.2','S64.1','S64.0','S23.1','S22.9','S54.9','S54.8','S54.7','S54.2','S54.1','S54.0','S53.1','S53.0',
'S52.9','S52.8','S52.7','S52.6','T10','M45','T12','T08','S52.5','S89.7','T92.2','T92.1','S73.1','S73.0','S72.9','S72.8','S72.7','S72.4','S72.3','S72.2','S72.1','S33.2','S33.1','S22.1',
'S22.0','S22.4','S22.3','S22.2','Q66.1','Q66.0','M96.6','M84.3','M84.2','M84.1','M84.0','M20.1','M67.4','M54.5','M54.3','M01.1','M01.0','M00.9','M51.9','M51.8','M51.3','M51.2','M51.1',
'M51.0','M46.2','M49.0','M23.0','M25.7','M25.6','M25.4','M90.0','M89.3','M25.1','M25.0','M24.6','M24.5','M24.4','M24.0','M23.4','M48.5','M86.9','M86.8','M86.6','M86.5','M86.4','M86.3',
'M86.2','M86.1','M86.0','M85.6','M85.5','M85.4','M22.2','M22.1','M22.0','M21.6','M21.5','M21.4','M21.3','M21.2','M21.1','M21.0'),'ICD_CODE_LEVEL1_org'))
May be this:
=if(WildMatch([ICD_CODE_LEVEL1_org], 'T02.9','T02.8','T02.7','T02.6','T02.5','T02.4','T02.3','S43.3','S43.2','S43.1','S43.0','S42.9','S42.8','S42.7','S42.4','S42.3','S42.2','S42.1',
'S42.0','S62.8','S62.7','S62.6','S62.5','S62.4','S62.3','S62.2','S62.1','S62.0','S22.8','S22.5','S55.9','S55.8','S55.7','S55.1','S55.0','S32.7','S32.5','S32.4','S32.3','S32.2','S32.1',
'S32.0','S52.4','S52.3','S52.2','S52.1','S52.0','S93.2','S92.9','S92.7','S92.5','S92.4','S92.3','S92.2','S92.1','S92.0','S02.9','S02.8','S02.7','S02.6','S02.5','S02.4','S02.3','S02.2',
'S02.1','S34.1','T93.2','T90.2','T90.0','B97.3','S65.2','S65.0','S45.1','S45.0','S44.8','S44.7','S44.4','S44.3','S44.2','S44.1','S44.0','S82.7','S82.6','S82.5','S82.4','S82.3','S82.2',
'S82.1','S82.0','T93.1','T92.9','T92.8','T92.5','T92.4','T92.3','S59.7','A18.0','S64.2','S64.1','S64.0','S23.1','S22.9','S54.9','S54.8','S54.7','S54.2','S54.1','S54.0','S53.1','S53.0',
'S52.9','S52.8','S52.7','S52.6','T10','M45','T12','T08','S52.5','S89.7','T92.2','T92.1','S73.1','S73.0','S72.9','S72.8','S72.7','S72.4','S72.3','S72.2','S72.1','S33.2','S33.1','S22.1',
'S22.0','S22.4','S22.3','S22.2','Q66.1','Q66.0','M96.6','M84.3','M84.2','M84.1','M84.0','M20.1','M67.4','M54.5','M54.3','M01.1','M01.0','M00.9','M51.9','M51.8','M51.3','M51.2','M51.1',
'M51.0','M46.2','M49.0','M23.0','M25.7','M25.6','M25.4','M90.0','M89.3','M25.1','M25.0','M24.6','M24.5','M24.4','M24.0','M23.4','M48.5','M86.9','M86.8','M86.6','M86.5','M86.4','M86.3',
'M86.2','M86.1','M86.0','M85.6','M85.5','M85.4','M22.2','M22.1','M22.0','M21.6','M21.5','M21.4','M21.3','M21.2','M21.1','M21.0'),'ICD_CODE_LEVEL1_org')
Also not sure if the intention is to use static value for all these Codes or use the original value. Right now you have it as static value -> ICD_CODE_LEVEL1_org
May be you want this:
=if(WildMatch([ICD_CODE_LEVEL1_org], 'T02.9','T02.8','T02.7','T02.6','T02.5','T02.4','T02.3','S43.3','S43.2','S43.1','S43.0','S42.9','S42.8','S42.7','S42.4','S42.3','S42.2','S42.1',
'S42.0','S62.8','S62.7','S62.6','S62.5','S62.4','S62.3','S62.2','S62.1','S62.0','S22.8','S22.5','S55.9','S55.8','S55.7','S55.1','S55.0','S32.7','S32.5','S32.4','S32.3','S32.2','S32.1',
'S32.0','S52.4','S52.3','S52.2','S52.1','S52.0','S93.2','S92.9','S92.7','S92.5','S92.4','S92.3','S92.2','S92.1','S92.0','S02.9','S02.8','S02.7','S02.6','S02.5','S02.4','S02.3','S02.2',
'S02.1','S34.1','T93.2','T90.2','T90.0','B97.3','S65.2','S65.0','S45.1','S45.0','S44.8','S44.7','S44.4','S44.3','S44.2','S44.1','S44.0','S82.7','S82.6','S82.5','S82.4','S82.3','S82.2',
'S82.1','S82.0','T93.1','T92.9','T92.8','T92.5','T92.4','T92.3','S59.7','A18.0','S64.2','S64.1','S64.0','S23.1','S22.9','S54.9','S54.8','S54.7','S54.2','S54.1','S54.0','S53.1','S53.0',
'S52.9','S52.8','S52.7','S52.6','T10','M45','T12','T08','S52.5','S89.7','T92.2','T92.1','S73.1','S73.0','S72.9','S72.8','S72.7','S72.4','S72.3','S72.2','S72.1','S33.2','S33.1','S22.1',
'S22.0','S22.4','S22.3','S22.2','Q66.1','Q66.0','M96.6','M84.3','M84.2','M84.1','M84.0','M20.1','M67.4','M54.5','M54.3','M01.1','M01.0','M00.9','M51.9','M51.8','M51.3','M51.2','M51.1',
'M51.0','M46.2','M49.0','M23.0','M25.7','M25.6','M25.4','M90.0','M89.3','M25.1','M25.0','M24.6','M24.5','M24.4','M24.0','M23.4','M48.5','M86.9','M86.8','M86.6','M86.5','M86.4','M86.3',
'M86.2','M86.1','M86.0','M85.6','M85.5','M85.4','M22.2','M22.1','M22.0','M21.6','M21.5','M21.4','M21.3','M21.2','M21.1','M21.0'),[ICD_CODE_LEVEL1_org])
An alternatively to such (large) match-function could be to categorize them on script-level per mapping: Mapping … and not the geographical kind and/or to flag it there.
- Marcus
not working error msg (Error in calculation)
It's probably a small syntax issue with some missing comma or single-quote or similar and it's quite hard to develop and maintain such large expressions without problems like this. Therefore have a look on my answer below.
- Marcus
Hi Sagar,
I would really suggest you to work this out in the load script instead. Its good practice to keep your UI light and push most of the complex into the load script.
Thanks and Regards,
Sangram
Also,
Make use of the Wild match in your load script instead.
Check this out:
I think I am going to agree big time with Marcus here