Convert a Datarow to a string without the use of a loop (for each)

Help Activities
,
1

Hello,

I’m trying to convert a Datarow to a string without the use of a loop (for each).

Is there anyone that can help me?

2

Give a try at
strFlatten = String.Join(“|”, YourRowVar.ItemArray)

feel free to use any other column seperator char

2 Likes
3

Hi @Martin_Juel_Andersen

Welcome to UiPath community

Try with followings below:

  1. Use Build DataTable activity to create DataTable and say it as DTBuild
  2. Use Add Data Row activity and pass that DataRow and also enter the DataTable DTBuild.
  3. Use Output DataTable activity and it will convert DataTable into string.

Regards
Gokul

4

Convert it to a string for what purpose? Why are you trying to avoid For Each? There’s no reason to avoid it.

5

dt_variable.Rows(0).item(“”).ToString

dt_variabele is the name of your datatable.
the 0 in the rows is the first row, select what row you want to select and the item is to select what item you want from your datatable so you put a columnname to get the value of the cell.

6

Thanks, that worked!

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.