Hi Everyone,
I'm trying to automate 2 things here:
1. I'm trying to create a automated workflow that picks up the latest updated spreadsheet from my teams shared drive.
I have a shared drive that my team adds a new spreadsheet once a week like below :
- Appleproducts 02-19_2023
- Appleproducts 02-05_2023
- Appleproducts 01-28_2023
- I want the workflow to pick up the latest file "Appleproducts 02-19_2023"
2. I want the workflow to read 3 out of 7 tabs from the latest spreadsheet "Appleproducts 02-19_2023" that has a product number column(like a unique key) that I can join to our Database.
The Column in each tab is called " Product Number" and some of the rows have multiple values (separated by a comma) as such :
| Product number: |
| Apple-1234 |
| Oranges-579, Prunes-987 |
| Peaches- 789, Mangos-321 |
| |
| |
output:
| Product number: |
| Apple-1234 |
| Oranges-579 |
| Prunes-987 |
| Peaches- 789 |
| Mangos-321 |
| |
- I grab that newly output to pull data from our db as a join I believe with those exact values which would give me a bunch of new updates and columns etc... (example our database already has that "product number" column with the value " Apple-1234""
