Tables: Join two tables

Product_Request

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.

Meghan_550057

Separate request for CSV and Excel: https://community.pushbot.com/discussion/682/csv-and-excel-lookup-data-in-a-column#latest

Nicholas_187159

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"

Jeff_146001

@Nicholas_187159 Yes, I think it would solve for that.