When developing a process, you were provided with two datatables, DT1 and DT2, as shown below:
The process documentation specifies that the two datatables need to be modified to reflect the following DT2:
How should the properties of the Merge Data Table activity be configured?
To achieve the desired output in DT2, where both the 'Department' and 'Name' columns are present, you need to merge DT1 and DT2 by their common column 'ID' and then include both relevant columns in the final output. The correct merge configuration should involve specifying the 'ID' column as the key for merging and correctly combining columns from both data tables. The image in option B shows the correct configuration for merging the data tables by the 'ID' column while appropriately incorporating the 'Department' and 'Name' columns. Therefore, option B has the correct properties for the Merge Data Table activity.
Tested in studio, the answer is C.
All the four option shows the same output.
Answer = 'C', tested in uipath studio
Answer B
Ans : C