3 Replies Latest reply: Aug 11, 2010 4:27 PM by John Witherspoon RSS

    Group records in a single line

    Josetxo Amonarriz

      Hello,

      I have Table A, with this appearance:

      TransID - Line - DimID - DimValue

      1 - 1 - A - 11A

      1 - 1 - B - 11B

      1 - 2 - A - 12A

      1 - 2 - B - 12B

      2 - 1 - A - 21A

      2 - 1 - B - 21B

      and I need to convert it to:

      TransID - Line - A - B

      1 - 1 - 11A - 11B

      1 - 2 - 12A - 12B

      2 - 1 - 21A - 21B

      How can this be achieved in Qlikview?

      Thanks in advance.