Hello,
I have two DT with one column each one.
I would like to get a third DT with the duplicated values.
How could I do?
Hello,
I have two DT with one column each one.
I would like to get a third DT with the duplicated values.
How could I do?
Hello,
Thanks. After doing so how could I get only the duplicated values?
You need only duplicated values ?
Yes. After merging both data tables i need to get only the duplicated values
You can do like this
Build Datatable–DT3
Use For each row For DT1
Then in that use
IF : String.IsNullOrEmpty(LR)
Then leave it
Else
Add data row-----Data Array will be {Row(0)…tostring}
After For each row use Write Range
Way2
For Each Row DT1
For Each Row1 DT2
If Row1(0).tostring=Row(0).Tostring
Add data Row
Break
End of for each
Write range
Hi @EngAnalyst,
Please use join datatable activity use the column name and join should be a inner join . This is the simplest way to get items thats available in both datatables.
Thank You
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.