I have two datatables with one column each and merge them/create a new table, so that I have a table in the end that has also one column and contains only the values that were not in both of the original tables.
As an Example:
Table1: 1, 2, 3, 5
Table2: 1, 2, 3, 4
Table3: 4, 5
I hope my goal is clear. I´m sure there is an easy way to solve this, but i tried it with merge and remove duplicates activities as well as the join table activity. Unfortunately I wasn´t able to achieve the result I needed.
Thanks in advance!
one of many options would be to merge the two tables (we assume the column structure / names are the same
then we remove the duplicated values by
(From d in dtMerged.asEnumerable
Group d by k=d(0).toString.Trim into grp=Group
Where grp.Count = 1
Select r = grp.First()).CopyToDataTable
Hi @Timsener ,
There is another method we can use to achieve this requirement.
Use Join data table activity with Full join mode and assign DT1, DT2 to get the DT3.
Use Filter to remove the blank values those are not matched.
Please refer the attached work flow for your reference. if you wish you could try. thanks.
Join Demo.zip (17.4 KB)
Thanks @ppr @kirankumar.mahanthi1!
both solutions worked perfectly well
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.