Hi, I have a datatabledt and a clone copy clonedatatabledt.
Then a for each row in clonedatatabledt , if it fulfils certain criteria, I will use invoke method - import row from clonedatatabledt to datatabledt.
But i would like to modify one of the column for each imported row and the original row in datatabledt.
How do i do that?
Example:
datatabledt:
ID Name Remarks
001 A
002 B
For each row in clonedatatabledt,
if ID = 001, then import row from clone to datatable
Existing Output: datatabledt
ID Name Remarks
001 A
002 B
001 A
Intended output: datatabledt
ID Name Remarks
001 A Entry 1
002 B
001 A Entry 2