Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to remove duplicates from table

Hi All,

How to remove duplicates from table where multiple keys are involved.

In my case , I want to remove duplicates where [Main Project Name],  SKUID and [PMaterial Number] is same.

LOAD   

     [Main Project Name],

     [Project Status],

     SKUID,

     [SKU Status],

     [PMaterial Number],

     [PMaterial Status]

FROM

Project_list_status.xlsx

(ooxml, embedded labels, table is Sheet1);

Can you please help.

Thanks in advance.

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

TABLE:

LOAD

     Distinct

     [Main Project Name],

     [Project Status],

     [Project Start Date],

     SKUID,

     [SKU Description],

     [SKU Status],

     [PMaterial Number],

     [PMaterial Status],

     date

FROM

[data.qvd]

(qvd);

STORE TABLE into distinct.qvd (qvd);

View solution in original post

14 Replies
Anil_Babu_Samineni

Can you provide sample data on wall, May be inline memory data. Qlik can remove Duplicates automatically while loading script

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Not applicable
Author

Capture.GIF

Please find attached image where 2 records are shown out of which only first one should be shown.

Anil_Babu_Samineni

Can you post those on wall not the image, Interesting seems all are same. Will check from my end

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Not applicable
Author

I have attached sample data where I need single row based on comparison of project name , SKU and PMaterial.

vishsaggi
Champion III
Champion III

When you load this excel in Qlikview what is happening? you see two rows or only 1 row. For me i can see only one row of data. ?

Anil_Babu_Samineni

Even, I got one line itself. I think it mistake because you saved after edit there it could be fault with different character. So, The all characters should be same and case-sensitive.

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
avinashelite

I think you have not loaded the data to Qlikview and see the data only in excel ...load the data to QV and check if the data is same then QV will so that as always one

rahulpawarb
Specialist III
Specialist III

Hello Dipak,

Please refer attached sample application.

Regards!

Rahul

Not applicable
Author

HI Anil,

Yes you see only one record in the Qlikview output but when you store these contents in QVD file it shows two records and that is where i am facing problem i am putting this table in loop to generate new table but stuck due to issue with duplicate records.I am attaching qvd file for reference.