I want to create array

[pravin_bindage]

I want to create array of all values from single row.

@Anil_G @supermanPunch @Sudharsan_Ka
I want to create like this
ArrayStr → (Blue, Pink, Black, White)

ArrayStr1 → (Green, Yellow, Pink, Red)

[postwick (Paul Ostwick)]

The forum search feature works great.

Converting Data Table to an Array of String

I am having of a list of items in an excel which I want it in a string array. After reading the excel data using read range, how do I use the assign activity to convert the datatable data to my string array? I saw many similar discussions in the forum but it did not work properly for me. Please help me out on this. Thank you

[Sudharsan_Ka]

HI @pravin_bindage

If you loop into these values you can use like

CurrentRow.ItemArray

Regards
Sudharsan

[pravin_bindage]

I was trying this i’m getting this error - DataRow () can not converted to DataRow
@Sudharsan_Ka

[Sudharsan_Ka]

No need of {} there @pravin_bindage , try without it

[ppr (Peter Preuss)]

@pravin_bindage

DataRow () can not converted to DataRow

kindly note:

• from a DataRowVar.ItemArray access you will get returned an Array of Objects - Object()
• when using this within an add datarow the input argument - ArrayRow is to use

[postwick (Paul Ostwick)]

Don’t put {CurrentRow} put just CurrentRow

[pravin_bindage]

Only CurrentRow isnt working

[postwick (Paul Ostwick)]

Do you have this in a For Each Row in Datatable loop?

What are you trying to do? Where are you getting the row data?

[ppr (Peter Preuss)]

@pravin_bindage

Only CurrentRow isnt working

we mentioned

@ppr

kindly note:

• from a DataRowVar.ItemArray access you will get returned an Array of Objects - Object()
• when using this within an add datarow the input argument - ArrayRow is to use

[Sudharsan_Ka]

@Sudharsan_Ka

CurrentRow.ItemArray

Use this in the Array Row , No need {} @pravin_bindage

[postwick (Paul Ostwick)]

He can just put CurrentRow into the DataRow property. No need to convert to array.

[pravin_bindage]

URL.xlsx (9.1 KB)

In this excel there are many url which i need to open each url from every row by row & save image of that url with unique name which also given in excel at last column of each row.
Image names to be save
For 1st row - IMIBED-HD-00001_1 , IMIBED-HD-00001_2,…, IMIBED-HD-00001_6
For 2nd row - IMIBED-HD-00002_1 , IMIBED-HD-00002_2,…, IMIBED-HD-00002_6
.
.
.
Till last row same process
@postwick @Anil_G @Sudharsan_Ka @supermanPunch @Yoichi @sangeethaneelavannan1

[ppr (Peter Preuss)]

@postwick

He can just put CurrentRow into the DataRow property. No need to convert to array.

will throw an exception, when doing it

DataRowCollection.Add Method (System.Data)

Adding data row to data table. this row already belongs to another table

Hi i have a workflow. see below. In a for each loop it filters out some rows using regular expressions. I want to add these rows to a new datatable. Getting “this row already belongs to another table” error [image]

as a datarow has a navigation property to its holding DataTable (Property name: Table) it is recognized to which datatable the datarow belongs

[postwick (Paul Ostwick)]

Interesting, I didn’t know that. Good catch!