CSV and Excel: Join two spreadsheets
Meghan_550057
Posts: 107
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.
Tagged:
1
Comments
-
Similar request for data tables: https://community.pushbot.com/discussion/305/tables-join-two-tables/p1?new=1
0