5 Replies Latest reply: Nov 6, 2009 9:32 PM by José Andrés López RSS

    Set Analysis and Concat

    José Andrés López

      Hi, I have 2 tables like this:

      table1:
      LOAD * INLINE [
      account, Amount
      a, 1200
      b, 500
      c, 100
      ];

      table2:
      LOAD * INLINE [
      Group, Accounts
      g1, "a"
      g2, "a,b,c"
      g3, "b"
      ];

      i use set analysis and concat, to group:

      sum( {$< account = { $(=Concat(Accounts,',')) }>} Amount)

      but the result is the total (1800)

      [:S]

      Thanks all for the help,

      ja