Tables: Join two tables
Combine data from two tables, matching on a column that is common between the two of them, similar to CSV - Update file with another file.
Unlike the CSV action, this 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.
Comments
-
Separate request for CSV and Excel: https://community.pushbot.com/discussion/682/csv-and-excel-lookup-data-in-a-column#latest
0 -
Would this solve for the issue of not knowing all of the columns that will be updated, as is a requirement with "Update a Row"? Updates the column names that match and appends the columns that do not match, similar to "Join Excel Sheets"
0 -
@Nicholas_187159 Yes, I think it would solve for that.
0