Getting the value of a particular column from datatable without using for each row

[Kunal_Jain]

Hi,
I have a data table and I need to fetch the data from the particular column
Actually I am using 2 data tables and from the 3rd data table I need to get the data from the particular column.
How to do it?

[Jithesh_R (Jithesh Karkera)]

@Kunal_Jain ,
Try this

InputDT.DefaultView.ToTable(False,"YourColumnName")

This will return a single column from your DataTable

Regards,

[Palaniyappan (Forum Leader)]

Hi

To get data from one specific column and row

Stroutput = dt.Rows(rowindex)(“yourcolumnname”)

To get one entire column as a list of string

Stroutput = ( From row in dt.AsEnumerable() Select Convert.Tostring(row(“ColumnName”)) ) .ToList()

For all functionalities in datatable have a view on this tutorial

All about Datatable - UiPath

Hi All, Datatable - variable type is the most commonly used variable type by all UiPath users And it’s been the most often asked queries in forum especially on its manipulation So I would like to have this post as a repository for those who are looking for expressions related to Datatable Let’s go one by one keeping dt as name of datatable variable 1. Get number of rows in a datatable dt dt.Rows.Count (output - int32 type) 2. Get number of columns in a datatable dt dt.Columns.Count (output…

Cheers @Kunal_Jain

[Kunal_Jain]

It is giving output as tablename
not the required output

[Nitya1 (Nitya Tomar)]

Hi @Kunal_Jain

Use a For Each Row activity to iterate through the rows in the “dt3” data table.

Within the loop, use the Get Row Item activity to retrieve the value from a specific column.

The Get Row Item activity takes two parameters: the first parameter is the data table variable, and the second parameter is the name or index of the column you want to retrieve the value from.

Thanks!!

[Kunal_Jain]

I don’t have to use for each activity just to iterate one column

[Nitya1 (Nitya Tomar)]

Try this-

dtSelected = dt3.DefaultView.ToTable(False, “ColumnName”)

Thanks!

[Jithesh_R (Jithesh Karkera)]

@Kunal_Jain ,
It will provide a single Column .
you assigned it to the DataTable Right?
Put like This
DT_YourColumn =DT_Input.DefaultView.ToTable(False,"YourRequiredColumnName")

Here DT_YourColumn is the Output of type DATATABLE
and DT_Input is your Input DATATABLE

Regards,

[Kunal_Jain]

@Jithesh_R

DT_Input.DefaultView.ToTable(False,“YourRequiredColumnName”)

but to pass it in add data row I again need to pass it through for each row right??

[Jithesh_R (Jithesh Karkera)]

@Kunal_Jain ,
According to your requirement you need only one entire Column from your actual datatable right?
For that you need not do for each row you will get by doing the above method.
By the way why you are doing add data row?
Also If possible please share the sample input and the expected output

Regards,

[Kunal_Jain]

Well I need to pass the columns value into add data row as it contains the data for 2 datatables.
I cannot share the data

[Jithesh_R (Jithesh Karkera)]

@Kunal_Jain ,
You can share the sample input Dummy Input you can create and share and the expected output.

[Anil_G (Anil Gorthi)]

@Kunal_Jain

May I know how many rows are there in datatable and how many values are to be passed in add datarow

A small representation or explanation about the datatable will help

If its only one rows and you need aome column data then dt.Rows(0)("ColumnName").ToString will help

Cheers