i have two datatables ( dtResults and PartnerNames) i made a nested loop to iterate through the first dt and add the data from the second dt to each row (what i want is to combine each row of both dt to eachother but i faced the problem in syntax while adding the second dt alongside with other variables , how can i solve that ?
x 6729
What error are you facing?
By adding a data row into the current DataTable during iteration, the DataTable is being updated. So, you are getting an error.
If your DataTables share any common column names, utilize the activity ‘Join DataTable’ on the specified column name, or alternatively, you can merge those DataTables using the appropriate activity.
Hi @abdallah_abutaleb
Welcome to UiPath,
check that all values you combine inside the array are in the correct format, like - {row1(“ColA”).ToString, row2(“ColB”).ToString, var1} and make sure the number of items matches the columns in the target datatable.
If helpful, mark as solution.
Happy automation with UiPath
blank output from the highlighted syntax