Scenario 1 (Consolidating data across multiple bases)
- How can we combine common data from bases (assuming they have different number of columns and different information) into a single table that acts as the single source of truth? If not, what is the alternative for combining data from different bases into a single source of truth?
Scenario 2 (Consolidating data within a base)
How can we consolidate and merge data common information into a single table within the same base?
Assuming I have to use “Linked Records” to merge data, is there a way to “mass populate” link records instead of manually selecting each record?