A developer wants a new data table, dt_Result, that is only populated with common rows found in two data tables, dt_PreviousEmployees and dt_NewEmployees. Which activity should be used to perform this operation?
A developer wants a new data table, dt_Result, that is only populated with common rows found in two data tables, dt_PreviousEmployees and dt_NewEmployees. Which activity should be used to perform this operation?
To create a new data table, dt_Result, that is populated with common rows found in two data tables, dt_PreviousEmployees and dt_NewEmployees, the 'Join Data Table' activity should be used. This activity allows for combining rows from two tables based on a common field, which effectively yields the common rows between them.
Join Datatable