Unwanted iterations When I am running Excel Sheet

[Uma]

Hi,
I have Script like this,

Code:

DataTable.Importsheet"C:\QA\Zip1.xls",1,Global
wait(2)
If Browser("name:=MLSListings.com").Page("title:=MLSListings.com").WebEdit("name:=cityzip").Exist Then
Browser("name:=MLSListings.com").Page("title:=MLSListings.com").WebEdit("name:=cityzip").Object.focus
Browser("name:=MLSListings.com").Page("title:=MLSListings.com").WebEdit("name:=cityzip").Set DataTable("Zip", dtGlobalSheet)
wait(10)
Browser("name:=MLSListings.com").Page("title:=MLSListings.com").WebCheckBox("name:=RES").Set DataTable("RES", dtGlobalSheet)
Browser("name:=MLSListings.com").Page("title:=MLSListings.com").WebCheckBox("name:=CONDO").Set DataTable("CONDO", dtGlobalSheet)
Browser("name:=MLSListings.com").Page("title:=MLSListings.com").WebCheckBox("name:=LOTSLAND").Set DataTable("LOTSLAND", dtGlobalSheet)
Browser("name:=MLSListings.com").Page("title:=MLSListings.com").WebCheckBox("name:=MULT").Set DataTable("MULTI", dtGlobalSheet)
Browser("name:=MLSListings.com").Page("title:=MLSListings.com").WebCheckBox("name:=RENTAL").Set DataTable("RENTAL", dtGlobalSheet)

I have recored with the following values(now it is in Global Datasheet)
Zip RES CONDO LOTSLAND MULTI RENTAL COMM
95126 ON ON ON ON ON ON

After that I Parameterized( using Global data table).

-----------------------------------------------------------
My Excel Sheet Has following values

Row1 Zip RES CONDO LOTSLAND MULTI RENTAL COMM
Row2 94087 ON ON ON ON ON ON ON
Row3 94086 ON ON OFF ON OFF OFF ON

-----------------------------------------------------------
When I am Running I am Able to see the Excel sheet values in the Global data Sheet.It Looks like this

Row1 94087 ON ON ON ON ON ON ON
Row2 94086 ON ON OFF ON OFF OFF ON

------------------------------------------------------------
I used RUN ALL ROWS(In actions AND FILE-SETTINGS RUN)

The first iteration Iteration1(Row1 )Works correctly.It takes the 94087 values-correct

When it comes to the Iteraion2(Row2)It goes
Action1 Iteration1(row1).ItTakes the 94086 Value-Correct
Action2 Iteration2(row2)-I don't need this IterationIt search the page and it is giving error.
How can I avoid the Action2 Iteration2(row2)?
I tried with Row1-2 -It also gives the same problem.
I tried with one iteration(it works forist row,but i need to run the 2row also)
Result page is attached
Any Help?
Thanks for your time.
Thank you.
Uma

[Uma]

Hi,
I Gave Local parameter instead of Global.It is working.
Thx
Uma