I want to Update the Row value in Nested Foreach Row

Help Studio
, ,
1

There are 2 datatable where i need to update the Loadplan number based on the ordernum. Ordernum is the common in both datatble
Datatable1: OrderNumDT
Datatable 2: LoadPlanNumDT.

In OrdernumDT there is column called LoadPlanNum. Bylooping the ordernum in loadPlanDT i need to update the LoadplanNum in orderDT.

Any Leads helps … Thank you

The image shows a nested "For Each Row in Data Table" activity in UiPath, iterating through 'ordernumExcelDT' and 'loadPlanInfoDT' data tables to assign and update values based on specified conditions. (Captioned by AI)
The image shows a nested "For Each Row in Data Table" activity in UiPath, iterating through 'ordernumExcelDT' and 'loadPlanInfoDT' data tables to assign and update values based on specified conditions. (Captioned by AI)620×1140 32.6 KB

2

@niranjan.kodakandla

  1. Use look up datatable on second dt using the ordernumber and get the row index
  2. Using row index in the dt.Rows(rowindex)("ColumnName") ="Value to be updated"

You dont need a second loop as wel

Cheers