Forum Discussion
Use a single dataflow table to merge data with multiple fields?
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?
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
3 Replies
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
I went with example 1 and it seems to work fine. But if anyone has other/better solutions let me know.
Thank you for sharing😀
