Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have below table in Qliksense:-
In my raw data , I have unique records but in my Qliksense, I am getting double records and I am unbale to find the root cause for that.
PFA my data model script.
Can any one please help ?
Thanks in advance
I'd suggest checking the following:
1) There is, in fact, no duplication. One method to do this is to add RecNo() to your load and then using that in your table to make sure that there's no multiple rows with identical dimensions.
2) Any tables connected to the fact table, and used within the front-end table, are connected correctly and do not cause duplication. You can test this by removing any dimensions from said tables.
3) There is no duplication being caused through concatenation or joining of tables. This can often be tested by using Keep instead of Join/Concatenate, which allows you to keep the tables separate and testing each individually.