Hi @shirata.motoki
Welcome to UiPath.
Use the Join Data Tables activity to merge two tables, setting dt1 as the first input and dt2 as the second input. In the activity properties, select Full Join as the join type to ensure all rows from both tables are included, even if no matching values are found.
Open the Filter Builder and define the join condition by selecting the Email column from dt1, using the = operator, and selecting the Email column from dt2. This ensures that records with matching Email values are merged while unmatched rows from both tables are retained with null values in missing fields.
Assign the output to dt_Joined to store the combined result for further processing.
If you found helpful mark as a solution.
Happy Automation with UiPath.