Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Depurate excel table

Hi everyone,

I loaded an excel table into QV with Customer information (Contact name, Compañy, Telephone, email, etc). For example,I have rows with the same email. how can i show  in a straight table only the records that has not duplicate information?

thank a lot,

angel

2 Replies
Not applicable
Author

Could you post a sample data and application.

- Sridhar

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     You can use the "Distinct" keyword before your field name.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!