How to Move Data from One DataTable to Another datatable in Pega Automation.

[BaratamR (Baratam Raviteja)]

Hi Team,

i have requirement Need to Move one row of data in one Data table to another empty Data table.

How Can we achieve this.

if possible, please share how to manipulate the data in Data Tables or how to store the data in Empty Data Table.

or

please share Data table Projects Examples.

Thanks,
Raviteja.

[ThomasSasnett]

@BaratamR If you are getting your DataTable from a LookupTable, then you can define a duplicate LookupTable (create two with the same columns) and use the GetTable and ReplaceTable methods respectively to copy the data from one to the other. If your DataTable object is returned by something else (like a Query or a script or something), then you can use the Copy method of the DataTable. Here is an example.