how to remove duplicates from table

[#1]

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.

[Anil_Babu_Samineni]

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

[#3]

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

[#5]

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

[vishsaggi]

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.

[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]

Hello Dipak,

Please refer attached sample application.

Regards!

Rahul

[#10]

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.