Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Any one please its urgent.
Thanks & Regards
Use the distinct keyword to load only unique records:
LOAD distinct pname,
[Issuance Date],
[Departure Date],
TNo,
[Mobile No],
[E-Mail ID]
FROM ...etc;
Hi,
Thanks no but i want to display Duplicate records with in 7 days plus and minus. Can you present any sample file.
Thanks
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