Datatable Activity Help

[ppadarthi (Prudhvi)]

Hi All, can some one help me in extracting a specific column from a datatable and save it to a list

eg; sl.no Name city
1 Raju Hyd
2 Ravi Chennai
3 Ramu Pune

output to be name=[Raju,Ravi,Ramu]

[Parvathy (PS Parvathy)]

Hi @ppadarthi

Use the below LINQ:

nameList = (From row In dt.AsEnumerable() Select row.Field(Of String)("Name")).ToList()

nameList is of DataType System.Collections.Generic.List(System.String)

You can use below expression to print in Message box:

String.Join(", ", nameList)

Hope it helps!!

[ppadarthi (Prudhvi)]

Hi @Parvathy it helps, Thanks

[Parvathy (PS Parvathy)]

@ppadarthi

Glad to have helped

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has found…

Happy Automation!!

[sharazkm32 (Sharaz K M)]

Solution shared by @Parvathy will work as expected

Just to add one point to avoid confusion

Make sure that the output variable for storing array value is of type List

[singh_sumit (Sumit Singh Tariyal)]

Hie @ppadarthi use the below image refrence

cheers