XML Tag - Remove Duplicates from Excel

amankhan
amankhan used Ask the Experts™
on
Hi All,

   I am trying to use XML to load data from sql query in to excel.... But in Excel, I am getting duplicate records.... How I can remove duplicates.... Any XML tags to remove duplicates,...

Please find my xml, rtf and excel output attached....

Thanks
Aman
XXALMPAPROJREP-1.1.xml
sample-output.xlsx
XXALMPAPROJREP-2.0.doc
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Topic Advisor
Most Valuable Expert 2016
Commented:
How many records are in XXALM_PROJECT_REPORT_T and how is that table organized? I see a column PROJECT_NUMBER that will be the key for the table XXALM_PROJECT_REPORT_T but if I look at for example: PROJECT_NUMBER=St.Regis-DEV-ABD-JO and TASK_NUMBER=2.1 I see 5 records in your sample output but the last column has unique values, so no 'double' output as far as I can see.

Can you do this select and look at the output you get:

select * from XXALM_PROJECT_REPORT_T
where PROJECT_NUMBER='St.Regis-DEV-ABD-JO' and TASK_NUMBER='2.1';

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial