Separate Duplicate data

I have a list of numbers, as a column in a datatable: it looks like this:
1
2
3
4
4
5
5
6
7

I need to separate the items that are duplicated and store them in a separate table, so eventually i would have 2 tables that look like this:
1
2
3
6
7
and
4
4
5
5

What’s the best way to achieve this?
Thank you!

@siming
Have a look Here

Let US know your Open questions

Is it possible to not use AsEnumerable at all? I tried adding it to the xaml document in a note pad but I still get a error telling me it’s not part of the datatable function

Can you please Help us on giving some more Details. The Part with doing IT Notepad is unclear in Detail. Thanks

Have a Look Here as Well

This was the post that i followed to add the AsEnumerable() method, but it didn’t work. I still can’t use AsEnumerable() in my workflow

@siming refer to my Edited Post above. Here you can find a description to make asenunerable available

Like this:

Processusvierge.zip (8,0 Ko)

It worked exactly how i needed it. Thank you very much!!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.