4 Replies Latest reply: Apr 11, 2017 6:08 AM by Sasi Vardhan KV RSS

    Exclude records contain certain text

    Sasi Vardhan KV

      Hi,

       

      Here is the sample data have loaded:

      1. out of the given records need to take only that contain India(Used where condition)

      2. Out of records contain India need to exclude records that contain Maharashtra(can please let me know the condition need to include)

       

      Pls find the attached sample app for reference

       

      Test:

      LOAD * INLINE [

          Area, Amount, Unit

          Global/US/USA/LA/abc, 1, USD

          Global/US/USA/CA/abc, 1, USD

          Global/UK/London/LA/abc, 1, GBP

          Global/Asia/India/Karnataka/Bangalore, 20, INR

          Global/Asia/India/Maharashtra/Mumbai, 30, INR

          Global/Asia/India/Karnataka/Bangalore, 40, INR

          Global/Asia/India/Maharashtra/Mumbai, 50, INR

          Global/Asia/India/Karnataka/Bangalore, 60, INR

          Global/Asia/India/Maharashtra/Mumbai, 70, INR

          Global/Asia/India/Karnataka/Bangalore, 80, INR

          Global/Asia/India/Karnataka/Bangalore, 90, INR

          Global/Asia/India/Maharashtra/Mumbai, 10, INR

          Global/Asia/India/Karnataka/Bangalore, 20, INR

         

      ];

       

       

      Main:

      Load *,

      Unit as Measure

      Resident Test where wildmatch(Area,'*India*');

       

       

      Drop Table Test;