- 1.
push all data from source tables into central table using the "Push Table Data" action
- a.
This action will keep updating the same row
- b.
Include the unique ID you're using in your push
2. Use multiple "Look up single row in other table" action to pull the data you want from your various tables
3. Enable table deduplication on your central table