Multiple Iterations from same Data Sheet

Ask general questions here.
Posts: 7
Joined: Fri Jul 10, 2020 3:18 am

Multiple Iterations from same Data Sheet

Post by AutomationViaRano » Wed Jul 15, 2020 10:15 pm

Hi Team,

I want to perform a Automated Test in which my data excel sheet has 10 rows and similar data related to a Purchase Order.
Requirement is to created 10 Purchase Order while referring the data from the data sheet.
As of now, only ONE data is being picked and Purchase Order is created. And the Test Ends.

What could be the possible reason and solution for this.

User avatar
Ranorex Guru
Ranorex Guru
Posts: 6553
Joined: Mon Aug 13, 2012 9:54 am
Location: Zilina, Slovakia

Re: Multiple Iterations from same Data Sheet

Post by odklizec » Fri Jul 17, 2020 9:00 am


What you need is to create two smart folders with data connectors, where the one with purchase order details is nested in main smart folder with 10 rows. Something like this:
[MainSmartFolder] - smart folder with main data connector with 10 rows
|_[PurchaseOrderDetails] - smart folder with PO details
The test runs firs row from main data connector and performs all rows from second data connector. Then it goes to second row form main data connector and again performs all rows form second data connector and so on. Hope this helps?
Pavel Kudrys
Ranorex explorer at Descartes Systems

Please add these details to your questions:
  • Ranorex Snapshot. Learn how to create one >here<
  • Ranorex xPath of problematic element(s)
  • Ranorex version
  • OS version
  • HW configuration