How to convert IEnumerable variable into Datatable?

[faraz.ahmed9 (Faraz Ahmed)]

I have data in excel containing nic number and gender. I want to group the data according to gender. Which I have achieved using linq query:
(
From row In dt
Group row By k=row(“Gender”).ToString.Trim
Into grp=Group
Select grp
)

But the result is saved as IEnumerable variable and I want to write result in Excel File.

[rlgandu (Rajyalakshmi Gandu)]

@faraz.ahmed9

Main
├─ Read Range (ReadExcel)
│ └─ Input: “path_to_your_excel_file.xlsx”
│ └─ Output: dtData (DataTable)
│
├─ Assign genderGroups
│ └─ (From row In dtData.AsEnumerable()
│ Group By gender = row.Field(Of String)(“gender”) Into Group
│ Select Group.ToList()).ToList()
│
└─ For Each (group In genderGroups)
└─ Log Message
└─ "Group: " + group.Key
└─ "Count: " + group.Count.ToString()
└─ “Details: "
└─ String.Join(”, ", group.Select(Function(r) "NIC: " + r.Field(Of String)(“nic number”) + ", Gender: " + r.Field(Of String)(“gender”)))

[Syed_Muhammad_Kashif_Alam]

male female.zip (168.6 KB)
Hi Faraz,
I have made Some changes to your query this should work, Please try this.
(
From row In dt
Group row By k=row(“Gender”).ToString.Trim
Into grp=Group
Select grp.ToList
).SelectMany(Function(x) x).CopyToDataTable

Thanks