Forum Discussion
Solved
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...
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
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