5 Replies Latest reply: Aug 1, 2012 8:03 AM by Pradip Sen RSS

    How to bring 5 rows to 2 rows

    Henco van Ee

      Hi all,

       

      Maybe a bit of a strange question, but I really need to have this

       

      In QlikView I have the following data:

       

      CUSTOMERORDERID
      Customer X15154
      Customer X21644
      Customer X22564
      Customer X22578
      Customer X54650

       

      I need to make a straight table with the name | address | zip | city. In case that a customer has more then one ORDERID, I need to see the specific customer two times, or in other words two lines with the same data. The outcome of the example data above needs to be like this:

       

      CUSTOMERADDRESSZIPCODECITY
      Customer XAddress customer XZipcode customer XCity customer X
      Customer XAddress customer XZipcode customer XCity customer X

       

      It doesn´t matter where I solve this: it can be in the script as well as in an expression. I'am thinking about flagging and counting, but untill now I can't get it done. I hope some of you can help me out.

       

      Cheers,

      Henco