5

I have 1,150 test cases in my QC ALM and in Excel spreadsheet I have 1,075 test cases. There are 75 test cases which are duplicate in QC ALM and I need to remove them so that it matches the Excel test case count of 1,075.

Is there any way to find and remove duplicate records from QC ALM?

Improve this question
7
  • Can't you export all tests from QC to excel? and remove duplicate using excel.
    – Narendra Chandratre
    Aug 23, 2016 at 11:35
  • Delete the test cases from ALM; import from Excel. Should cover the requirement.
    – Dave
    Sep 6, 2016 at 9:49
  • 1
    The TC ID is always unique in QC ALM (assuming all the test cases are present under one folder). So, your duplicated tests should be having TC IDs that are not present in your excel sheet. In this scenario, you can export TCs from QC to an excel sheet and do a vlookup against the original excel sheet. If the TCs are present in different folders, then there is a possibility that a single TC exist in different folders with the same ID. In this case, the solution provided by @NarendraC is the best.
    – Janaaaa
    Sep 28, 2016 at 8:20
  • Still this Q is in active queue. Can you accept any answer if found helpful, please?
    – Narendra Chandratre
    Sep 30, 2016 at 5:24
  • OK, will try today with your scenario. If I get any issue will let you know.
    – Bharat Mane
    Sep 30, 2016 at 5:32

1 Answer 1

Reset to default
1

Solution:

  • Export all the tests from QC to excel
  • Using power of Excel you can remove duplicate test easily
Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.