How to iterate through each row and display it as string?

[B.D]

Hi,

I want to iterate through each row of an Excel file and compare that to another row of a diffrent file. For this I started with a for each row loop:
for each row in DT → assign: rowstring = row.toString
message box displays “system.data.datarow”

what’s wrong ?

thanks
B.D

[pattyricarte (Patty Boy)]

@B.D Can you share your xaml or screenshot. To easily address the issue.

cheers
Happy learning

[srdjan.suc]

You can use “String.join(”,“,Row.itemArray)” in Assign activity to place whole DataRow to a String

[Emman_Pelayo]

@B.D

for each row in DT → assign: rowstring = row.toString
message box displays “system.data.datarow”

You need to specify the column index or column name you want to get from the datatable.
i.e. rowstring = row(0).ToString or row(“YourColumnName”).ToString

[ImPratham45 (Prathamesh Patil)]

because it is an array of data i.e. all columns data present in that row
So you can write it like
Row(“Column Name”).tostring
or
if u know the index of column
Row(0).tostring------for 1st column

[Sriram07 (Sriram Sundharraman)]

Use row.itemArray() and assign to any array variable with string format.

Or use get row item activity and pass the item(row) and column name print it…

Hope it helps.

[B.D]

can’t it check the entire row ?

[VladTof (Vlad)]

As your title say you want just to display the row and the best way in my opion is the solution posted by @srdjan.suc .

If you want to compare an entire row with another to check if it is the same I think you have to extract each value from every column and compare it.

To access the value use: row(column_index)

Hope to help you.
Regards

[B.D]

Awesome exactly what I needed. to get this right… So “string.join” joins each item to a single string format of the string array, “,” marks the seperation of the elements and “row.itemarray” specifies the type of the array ? Or did I get it wrong ?

[srdjan.suc]

Yes exactly that