6 Replies Latest reply: Dec 22, 2017 2:33 AM by Francesco Valente RSS

    Straight table removes duplicate

    Francesco Valente

      Hi community I am newbie in Sense,

       

      I am joining two qvd files with an inner join and I am then creating a table object with the result data.

       

      The problem I am running into is that the table is removing duplicates. Is there a way I can keep it.

      All "include null values" boxes have been ticked along with "Include zero values" in the data handling section.

       

      I have spotted this with a count column on a variable I am interested in, as per below, the variable "Position"= 0 has a count of 19 but if I remove the count column I do only have one row showing 0 in the table.

      table_no_duplicates.png

       

      Is there something that I am missing, which removes the duplicates or is it an auto function?

       

      Thank you in advance