celfa
(Claus)
#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 
PAD
#2
Hi @celfa
how about adjusting and applying the solution proposed by @Bharat in the thread:
PAD
#3
Try this workflow - does it solve your problem? 
split datatable.xaml (9.2 KB)
4 Likes
celfa
(Claus)
#4
Thanks! That is perfect
. Exactly what I was looking for.
system
(system)
closed
#6
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.