Hi, there are different approaches for this but based on what I read the general approach is this:

1. Read the whole contents of the table into a variable in Step 1. Rows and columns will be delimited with the character you choose. Let's call this variable "tabledata".
2. In Step 2, use the Split AC to "cut" the topmost row from the table variable into a variable called "currentrow", leaving the remainder in the original variable "tabledata".
3. In Step 3, perform the data entry in notepad with the text in "currentrow" (you may need to split "currentrow" for specific fields).
4. At the end of Step 3, perform a Go To advanced command to move back to Step 2, which will then proceed to cut the next row from "tabledata"
5. This loop will keep repeating until there are no more rows left in "tabledata" after which you can then end the wizard.

I hope this helps, let me know if you need more clarification.

Thanks,

Darren

Thanks Darren for your reply.

Sorry, I don't really get you..

First in step 1, how to read the whole table content? Use Get HTML table function? My table is look like as below.

I see. So this is a web app.

The method of extraction depends on the business app and how it stores and displays the data. If there is an easy way we should try that before resorting to manipulating the UI. Is there an export feature in that app? For example, export to Excel, CSV, etc? If there is you can export your data and use the "Copy from Excel" AC to store the data in a variable.

The "Get HTML Table" AC looks for and extracts data from

If the data isn't in a

In order to provide a definitive solution I'd need access to the website to inspect it. So unfortunately I can only provide guidelines at this stage.

Hi, there are different approaches for this but based on what I read the general approach is this:

1. Read the whole contents of the table into a variable in Step 1. Rows and columns will be delimited with the character you choose. Let's call this variable "tabledata".
2. In Step 2, use the Split AC to "cut" the topmost row from the table variable into a variable called "currentrow", leaving the remainder in the original variable "tabledata".
3. In Step 3, perform the data entry in notepad with the text in "currentrow" (you may need to split "currentrow" for specific fields).
4. At the end of Step 3, perform a Go To advanced command to move back to Step 2, which will then proceed to cut the next row from "tabledata"
5. This loop will keep repeating until there are no more rows left in "tabledata" after which you can then end the wizard.

I hope this helps, let me know if you need more clarification.

Thanks,

Darren

Thanks Darren for your reply.

Sorry, I don't really get you..

First in step 1, how to read the whole table content? Use Get HTML table function? My table is look like as below.