Extract link information from Extract Table

[ajit]

Hi,
I am currently evaluting AA for extracting data from different sites. My requirement is go to a search results page containing a table containing various links. I need to go to each link of search result and pick up the data from that page. In order to do that, i used Extract Table functionality in AA to iterate thru each row in Internet explorer table thru the search results page. I was able to get all values in the tables but unable to get the link as it only displays the text. How can i extract the link information to browse further for extracting information.

Thanks

[forumsupport]

Hello,

Please try this, in your task after the command of Extract Table use loop command with an option of “Each row in internet Explorer Table”. This will allow you to get the data from each row of the table extracted command in the task.

Than using Web Recorder’s command (from Internet categories of Task Editor) use “Manage Web Control”. Insert the URL and launch it and record the click on any one of required link from the Table. Now once you have recorded you will notice that in Web Recorder window in the Text box of “Name” the name of the link will be displayed. Replace that name of the link with the “Table Column (1)” system variable by pressing F2 button. Save the task.

Here please enter the Table Column () number for which required link is displayed. You can get it from the CSV generated by doing Extract Table.

Hope this helps.

[ajit]

Hi,
I used Loop command with an option of "Each row in Internet Explorer table". It does get me data from each row. But when i use the "Manage Web Control", i have to put in the URL for the search page and not the serach results because the search results are not present and i cannot go to the same. Is there an option of going to another page than put it some values and then go to actual page in Manage Web Control Launch option. Please find a sample task associated with a public site it will make things more clear.

[forumsupport]

Hello Ajit,

We looked into your task and in Advanced Settings of "Manage Web Control" command 'Index' option was checked or enabled due to which the task was clicking on same link although the name of link is changing. You need to select the 'Name' option instead so that task clicks on a link by its name.
If layout of webpage is same then Web recorder will take care of changing parameters in a URL.

We have amended the task for your convenience. Please copy it under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder.

Hope that helps.