2 Replies Latest reply: Feb 25, 2016 8:03 AM by Alessandro Saccone RSS

    Concatenate

    Shyamala Mahendran

      I have a table for ex

       

      ABA1A2B1B2
      hs11131416
      hs12131417
      hs12141518
      hs78869876

      i want to get

       

      A/BTypeValue
      hA11
      sA13
      hB14
      sB16

       

      so i wrote a query like

      A:

      LOAD

      A as 'A/B',

      'A' as Type,

      A1 as Value

      from table1;

      Concatenate

      B:

      Load

      B as 'A/B',

      'B' as Type,

      A2 as Value from table1;

       

      but the second part not getting concatenated