15-07-21 12:20 PM
Answered! Go to Answer.
16-07-21 02:47 AM
Hi Rinesh,
Using code stages/custom object is easier.
But if your business has restrictions, could try the below method.
1) Create an empty collection (ColB), assume existing collection is ColA
2) Do a nested loop starting with ColA, if row does not exist in ColB, add row to ColB.
3) You can choose whether to delete or retain the copied row in ColA.
Hope this helps.
Thanks,
Avinash
15-07-21 01:01 PM
15-07-21 01:48 PM
15-07-21 02:24 PM
Dim pNewDataTable As DataTable
Dim pCurrentRowCopy As DataRow
Dim pColumnList As New List(Of String)
Dim pColumn As DataColumn
For Each pColumn In Input_Col.Columns
pColumnList.Add(pColumn.ColumnName)
Next
pNewDataTable = Input_Col.DefaultView.ToTable(True, pColumnList.ToArray)
Out_Col = Input_Col.Clone
For Each pCurrentRowCopy In pNewDataTable.Rows
Out_Col.ImportRow(pCurrentRowCopy)
Next
And make the following outputs and inputs
Input:
Output:
15-07-21 08:30 PM
16-07-21 02:47 AM
Hi Rinesh,
Using code stages/custom object is easier.
But if your business has restrictions, could try the below method.
1) Create an empty collection (ColB), assume existing collection is ColA
2) Do a nested loop starting with ColA, if row does not exist in ColB, add row to ColB.
3) You can choose whether to delete or retain the copied row in ColA.
Hope this helps.
Thanks,
Avinash
16-07-21 07:50 AM
16-07-21 10:55 AM
16-07-21 02:40 PM
16-06-22 11:57 AM