How to move column data into DataRow[] variable

Hello Team,

i want to move all the data in particular column of a data table to datarow varible
how can i do that?

thanks inadvance.

1 Like

HI @asha_TN,

Convert Column in to item array, and then use add data row activity and pass the column.itemarray variable to activity.

Thank You,
Shubham Pratap

2 Likes

Hello @Shubh1801

how to convert column in to item array ?

-Thanks

2 Likes

Hi @asha_TN,

Use
datatableVariable.AsEnumerable().Select(Function (a) a.Field(of string)(“Column Name”).ToString).ToArray()

Attached flow for exampleColumnToDataRow.zip (19.5 KB)

Thank You
Shubham Pratap

2 Likes

Hello @Shubh1801

Thanks for your time,

The scenario is , Step1: i have a column values says num1, num2, num3 …and i want to store these values in different variables like v1=num1, v2=num2, v3=num3…
Step 2: there is a data table having 4 cloumns, i need to seach v1 in column 1 , if i found v1 then i have to go to column 4 of same row ( row of the v1 we found) n check for the remaining variables v2 and v3 .

how can i do this ?
any idea?

2 Likes

Hi @asha_TN,

Yes, this can be done, can you send me excel with sample data, i’ll build it for you

Thank You,
Shubham Pratap

1 Like

Hi @Shubh1801

In the attached excel file my column values of first table are 97112
97530 and i have to assign these values to v1 n v2 respectively n search in table 2 with above step 2 rules.Test.xlsx (11.5 KB)

2 Likes

Hi @asha_TN,

PFA Attached, run from Solution_select.xaml
dtOutput will have 1st column from table 1 and 2nd column as 4 th column of Table 2,

ColumnToDataRow.zip (24.9 KB)

Please let me if any issues,

Thanks You
Shubham Pratap

1 Like

Hi @asha_TN,

Hope this solution has resolved your issue…?

Thank You,
Shubham Pratap

1 Like