1 Reply Latest reply: Jul 21, 2011 10:14 AM by Iulian Carlan RSS

    Combine/permute two table fields (A,B) (1,2) (A1,A2,B1,B2)

      Hi,

       

      Does anybody know what should be the best way to permute/combine in script two table fields into one?

       

      Example:

       

      Table1:
      LOAD * INLINE [
          F1
          A
          B
          C
          E
          E
      ];


      Table2:
      LOAD * INLINE [
          F2
          1
          2
          3
      ];


      Result expected:
      Combination_field
      A1
      A2
      A3
      B1
      B2
      B3
      C1
      C2
      C3
      D1
      D2
      D3
      E1
      E2
      E3

       

       

      THANKS!