I am using excel application scope to read an excel file.
I have two rows of data in my file:
I want to go to the following website and scrape a table for each row above.
the URL should look like this.
URL1 = https://au.finance.yahoo.com/quote/AAPL/financials?p=AAPL
URL2 = https://au.finance.yahoo.com/quote/AMZN/financials?p=AMZN
I am using for each row to read contents of excel and store it in a variable called SearchValue using Assign activity.
How do I then create the URL which I can pass into open browser and make the process dynamic.
I tried the same approach i.e. using Assign activity but could not.
Could anyone please help me.