Linq/group ToString

[NHoe (Norman)]

Hi all, is it possible to output the current grouped value for a log message as a string?

(From d In inputDT.AsEnumerable
Group d By k=d(“Test”).toString.Trim Into grp=Group
Select g=grp.CopyToDataTable).toList

[ppr (Peter Preuss)]

a quick way would be to use the output datatable activity for creating the string

Result | List(Of Datarow) =
(From d In inputDT.AsEnumerable
Group d By k=d(“Test”).toString.Trim Into grp=Group
Select g=grp.CopyToDataTable).toList

then we create quickly the data table with Result.CopyToDatatable

As alternate we can use a custom LINQ

[NHoe (Norman)]

@ppr thank you, I have tried but I get the message “Expression end expected”

What could the custom LINQ look like?

[ppr (Peter Preuss)]

A custom LINQ could look like this:

String.Join(Environment.NewLine, Result.Select(Function (x) String.Join("|", x.ItemArray)))

@NHoe

I have tried but I get the message “Expression end expected”

can you show some screenshots of what you have done?