2 Replies Latest reply: Jul 19, 2013 9:03 AM by Vishwaranjan Kumar RSS

    copy records of one row to all other rows based on ID

    Thorsten Schröder

      Hello community,

       

      I have the following DB-table:

      table.PNG

      What I want to achieve is to copy the records of row no. 1 for the columns customer, project, plant where sheetname = "sheet 1" based on ID.

      I don't want to insert the records to the DB, all I want is to get rid of the null values and get the rigtht output (not just row 1) when I select a certain customer for example.

      Is this something I can do with a qlikview script (if yes - how?) or do I have to go the SQL way?

       

      thank you.