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.



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


      Thank you in advance