Use a single dataflow table to merge data with multiple fields?

[arock-well]

I have a single Employee dataflow table in my new dataset. Within the dataset I have other tables I've brought in that need to look up employee information in that table based on a unique employee ID field. When merging data, should I just use that same Employee table to merge with the various employee IDs? Or should I bring in unique instances of the Employee table for each of those employee ID fields to lookup?

[v-angzheng-msft]

Thank you for sharing😀

[arock-well]

I went with example 1 and it seems to work fine. But if anyone has other/better solutions let me know.

[arock-well · Accepted solution]

Example 1: One Employee Table (join on EmployeeID)

Employee  ---> Table 1, Table 2, Table 3

Example 2: Multiple Employee Tables (join on EmployeeID)

Employee ---> Table 1

Employee (1) ---> Table 2

Employee (2) ---> Table 3