7 Replies Latest reply: Mar 26, 2014 5:15 AM by Diego Camacho Moreno RSS

    Joining two tables based on wildcard values.

      Hi all,

       

      is it possible to make a join using wildcard values? With this code will be easier to understand what I am trying to get:

       

      T1:

      LOAD * INLINE [

      Account

      6%

      70%

      800%

      ];

       

       

      T2:

      LOAD * INLINE [

      Account, Import

      6, 1

      7000000, 2

      8000000, 3];

       

       

      Inner Join(T1)

      Load

        Account,

        Import

      Resident T2;

       

       

      Drop Table T2;

       

      This code wroked as expected (not how I liked). What I want to get is to join but using wildcard values (70% <-> 7000000) instead of perfect matchs. is it possible? is there any other way? I know Wildmatch() function and the like, but I need the wildcard in the join.

       

      Thanks so much !!!