How to iterate over Columns and only one row

[Doonline (Doonlinejob23)]

Hii,

I Have a range of columns on which i wanted to iteration.
Also i have a row index on which i want to iterate my coumns.

But my issue is I dont know how to loop on one row and all columns.

Means ,Suppose at row 16 i want to iterate on evry column.

so how do i write logic for this.

please help

[pravin_calvin (pravin kumar)]

Hi @Doonline

Have a view on the thread below!

Foreach Column?

First foreach is you are looping through all the rows. foreach (DataRow dtRow in dtTable.Rows) [image] 2nd foreach is inside 1st foreach is you are looping through all the columns of that specific row. foreach(DataColumn dc in dtTable.Columns) [image] Instead of index you can use if condtion to check column name if dc =“status” and perform your logic [image] var field1 = dtRow[dc].ToString(); To get the Index value which you need, use below int index = dtRow .Table.Columns[“status”].Or…

Regards

[Doonline (Doonlinejob23)]

No thats not my requirement

[THIRU_NANI (NaNi)]

Hi!

if you want only one row you can simple use get row item

Regards,
NaNi

[Doonline (Doonlinejob23)]

I dont want row.
I have it.
only on that row i want to iterate my column

[pravin_calvin (pravin kumar)]

Hi @Doonline

Suppose we are assuming that creating the index variable in for each row

You need to iterate over column means

Currentrow(idx).tostring will give the result as per row index!

Regards

[THIRU_NANI (NaNi)]

Hi!

In that case try like this

DataTable.Columns(Index).ColumnName

Regards,
NaNi

[Doonline (Doonlinejob23)]

This will give me the index of column

[jack.chan]

heres an example:
e.g. you have a datatable called “dt” then you assign the 16th row to a DataRow variable called “row16”

• you can use a foreach loop, where typeArgument = “DataColumn” and values = “dt.Columns”, to loop over all the columns of that datatable,
• to loop over the columns of “row16”, just do row16(item.ColumnName).toString on each iteration
  
  
  
  When i run this sequence you can see that it only prints out the column values for that particular row
  

Sequence.xaml (10.6 KB)

[Ramya_K]

@Doonline ,

You can use For each row and while loop to loop through all columns of a particular row.

First, we can get the column count of datatable.
Then, use for each row & while activity. For this purpose, I have just used a log message.

Hope this helps. Happy Automation!!!

[ppr (Peter Preuss)]

iterating over all column values of a particular row we can use the itemArray of that row

YourDt.Rows(YourIndex).ItemArray - an Object array each item representing the particular column value

[kevin.jeronne.d.gador (Kevin G.)]

I think I have the same problem with him. He doesn’t have a data table present at the workflow level?

So he is iterating over a transaction item with a data type of DataRow. This DataRow he wants to iterate all over the columns of this. So we will have to think of how to iterate over with DataRow only.

[kevin.jeronne.d.gador (Kevin G.)]

hello I managed to solve my own problem. If this is also your problem, here’s what I did

I created a variable that will store my data columns, in order to achieve this create a variable with a DataColumnCollection.

use assign activity.
variable of DataColumnCollection = name of data table where your data row is coming from.Columns

So this will store all the columns available in the data table. As for me, I am working with REFramework so I used it as an argument instead ( out_ColumnNames), I also created a variable in the Main to pass the out_columnnames.

and then in the workflow you’re working with,

use a for each, set type argument to DataColumn (not datacolumncollection),

as for me
Column in in_ColumnNames

Column - will return the names of your columns
inside this transaction_item(Column) - will return the value inside

My transaction_item is of type DataRow