How to split datatable into several datatables based on 1 unique key

#1

Hi guys,

I’m looking for suggestions of how to split a datatable into more datatables dynamically based on 1 key(ID) in the table.

My initial datatable look like this:
ID VARIANT
850 85
850 95
850 100
1107 20
1107 30
1107 40
1107 50

And I want to split each ID into a new datatable:
Name of Datatable: 850
ID VARIANT
850 85
850 95
850 100

Name of Datatable: 1107
ID VARIANT
1107 20
1107 30
1107 40
1107 50

It needs to be dynamic because the number of unique ID’s are fluctuating.

Hope some of you could give a few hints of how to do this kind of task :grinning:

Ungroup rows in Excel
#2

Hi @celfa
how about adjusting and applying the solution proposed by @Bharat in the thread:

#3

Try this workflow - does it solve your problem? :slight_smile:
split datatable.xaml (9.2 KB)

2 Likes
#4

Thanks! That is perfect :grinning:. Exactly what I was looking for.

#5

No problem :slight_smile:

#6

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