I’m doing a practice project where I get the prices of items from three different supermarkets and have to use this data to produce an output spreadsheet.
On the spreadsheet, I’d like 3 tabs. 1 for each supermarket listing the product and the cheapest price e.g
ASDA Baked Beans 29p
Chicken Breast pieces £1.29
Apples 40p etc
Morrisons Baked Beans 32p
Chicken Breast pieces £1.45
Apples 44p etc
To get to this stage, is it best to have one data table that has all the products in for each supermarket (e.g one data table for all Tesco products, one data table for ASDA products) or a separate data table for each product for each supermarket (e.g a data table for individual shopping items for Tesco e.g a data table for Tesco apples, a data table for Tesco chicken breast etc the repeat for other two supermarkets)?
Then to get the cheapest product from each supermarket, would that be a case of using the filter data table activity to filter out the data table to get the cheapest product for each item in the supermarket so all others are disregarded (e.g searching for baked beans returns around 50 items, I want the cheapest one)?
Finally, to paste the final shopping list items on to the spreadsheet, how will I get Ui Path to paste in to the ‘next empty cell’ e.g if columns A2 and B2 say ASDA Baked Beans 29p, how will Ui path know to paste Chicken Breast pieces £1.29 in to columns A3 and B3?
Sorry there are a number of questions here - quite a few important principals for me to learn!
Any help much appreciated,