Duplicate data for within 7 days

[#1]

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

[#2]

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;

[#4]

Hi,

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

Thanks

[#5]

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