Combining Columns from Separate Tables
I have two tables with the same count of rows. Is there an easy way to take two columns from those tables, and put them alongside one another in a new table? There is no unique identifier to do Tables: Update a row with a batch.
I just want to add that I've also tried Tables: Copy a table to another table and that was not suitable for the use case. Even though values are written to the proper column, they're added in the row following the last value in the first column.
Best Answer
-
Thomas what you can do is use the Tables: Apply formulas action to set a unique identifier based on the row index in both tables and then update row by row. I see this isn't documented in the Tables: Apply formulas to columns article but it is documented in the action configuration page. I will follow up with Max to get it documented.
5
Answers
-
Thanks Dylan. This should work perfectly.
0