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

Duplicate data for within 7 days

Hi All,

I have to show Duplicate records and data which is comes under with in 7 days like in sample pname = B is comes within 7 days like min date is 2012-11-11 and max date is 2012-11-17.

Thanks

4 Replies
Not applicable
Author

Any one please its urgent.

Thanks & Regards

Gysbert_Wassenaar

Use the distinct keyword to load only unique records:

LOAD distinct pname,

     [Issuance Date],

     [Departure Date],

     TNo,

     [Mobile No],

     [E-Mail ID]

FROM ...etc;


talk is cheap, supply exceeds demand
Not applicable
Author

Hi,

Thanks no but i want to display Duplicate records with in 7 days plus and minus. Can you present any sample file.

Thanks

Not applicable
Author

Hi,

I provide you new sample excel file where i have to display duplicate records like in yellow background and column in green sholud match exactly in a rows.

Thanks