7 Replies Latest reply: Apr 13, 2016 8:18 AM by Sunny Talwar RSS

    wildmatch

    sagar rahul

      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'))

        • Re: wildmatch
          Sunny Talwar

          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])

          • Re: wildmatch
            Marcus Sommer

            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

            • Re: wildmatch
              Sangram Reddy

              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