Hi I am scraping price data for a range of products from a e-commerce site. The price scrape will happen daily
I want to add the scraped price data everyday to a master file with prices added to a new column.
- How do i add the price data to a new column, is it possible to make write range activity to be dynamic for coloumn as well as rows?
- How do i get the column header to be the date of that respective date
I have done the robot up to scraping the data and filtering the data to the few products i want using Join data table activity as filtering tool. I’m stuck with how to get the prices in to a new column everyday and for the column header to have the date