3 Replies Latest reply: Jun 2, 2016 5:47 AM by Stefan Wühl RSS

    One to many match using wildmatch

    Ankit Tr

      Can anyone  help me out if the problem is to find one to many matches? I used for loop with wildmatch but the output has one row (proabably the last match) instead of multiple rows for each string.
      Here is an example:

       

       

      table1:

      LOAD * INLINE [

      match, description

      *LS01*, team1

      *LS02*, team2

      *LS03*, team3

      ];

      table2:

      LOAD * INLINE [

      string, value

      AALS01DDLS02, 10

      ABLS01EELSO3, 20

      ACLS02GG, 50

      LLLS02EE, 10

      RRLS03QQ, 50

      TTLS05QQ, 10

      ];

       

       

       

      The output required is:

       

      AALS01DDLS02, 10    team 1

      AALS01DDLS02, 10    team 2

      ABLS01EELSO3, 20   team 1

      ABLS01EELSO3, 20   team 3

      ACLS02GG, 50          team 2

      LLLS02EE, 10           team 2

      RRLS03QQ, 50         team 3

      TTLS05QQ, 10           others