7 Replies Latest reply: Mar 20, 2018 10:24 AM by Jahanzeb Hashmi RSS

    Merge rows based on specific conditions

    Christoph Albrecht

      I want to load the following table within the data load script.

       

      I have the following data table:

       

      DateValue1Value2
      DateAaV1
      DateAa-
      DateBb-
      DateBbV2
      DateCcV3
      DateDd-
      DateEe-
      DateFfV4
      DateFf-

       

      And I want to have a table like this:

       

      DateValue1Value2
      DateAaV1
      DateBbV2
      DateCcV3
      DateDd-
      DateEe-
      DateFfV4

       

      If two rows are identical except one field, I want to keep only the row which is not null. If there is only one row, then then keep the row with or without a null value.

       

      How would you do that in Qlik Sense data load editor?

       

      BR