CSV and Excel: Join two spreadsheets

Meghan_550057
Meghan_550057 Posts: 107
edited November 2019 in Ideas

Requesting an Excel action to match the CSV action, CSV: Update file with another file.
Unlike the current CSV action, both should have a parameter to join on all matches, not just the first one, when the column doesn't have unique values.

Example use case (2 data sets):
1. Employee asset data
2. Master/foundational data
User ID exists in both data sets and acts as the key. It can exist many times in the employee asset data but only once in the master/foundational data. Looking to return cost center, business unit, site from the master/foundational data set to the employee asset data and update every row.

1
1 votes

Swept · Last Updated

Released January 2020

Comments