Skip to main content

I have a simple wizard where I need to copy four columns from excel and paste the values in fields of a web base application.

My commands include:

**Get worksheet (Excel worksheet actions DAC); Copy from Excel (range of cells into a variable); Get Array Data (using column delimiter, I am separating each column value into a variable, to later ‘input text’ in the application)

My problem is when the command for Get Array Data pulls in the last column it also brings in the row delimiter and the value of the first column.    The command reads like this:  From the array stored in (my variable created from the Copy from Excel) Where items are delimited by $column delimiter$ Get the value of item #4 (since it is column 4).  My row delimiter is ***.  The value that is pulled in for the last column and stored in the variable reads something like this:  123456***123456789.  It pulls in the data in the last column AND the data in the first column of the next row.

Any help you have to offer with this would be much appreciated.

Hey there!

 

Try this:

Copy from Excel → myTable  → Row Delimiter µµ, Column delimiter ##   (can be exchanged to your liking)

Loop Table myTable, row delimiter µµ, store current row in myRow

  getarraydata #1 from $myRow$ seperator ##  →  data1

  getarraydata #2 from $myRow$ seperator ##  →  data2

  getarraydata #3 from $myRow$ seperator ##  →  data3

  getarraydata #4 from $myRow$ seperator ##  →  data4

  note (do something with that data) 

done

 

advanced command loop

 

 

Since you try to enter those data into a web-form I think you need to loop over several steps. To do this use the get-array-data twice and loop inside the steps:

 

Loop with exit in step 2

 

Diagram view for better understanding

Diagram view (using Google as example screen)

 

hope that helps

Sascha

Hi @CherylH 
Have you solved this issue?

@MillaZ - I have just received the notes and will begin working on this to see if it fixes my issues.

 

Thank you Sascha.  I am looking into this!

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings