Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Aspiring_Developer
Specialist
Specialist

Find and remove duplicate records in Qliksense

Hello All,

I have below table in Qliksense:-

Aspiring_Developer_0-1661859189475.png

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

 

 

Labels (1)
1 Reply
Or
MVP
MVP

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.