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.
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.
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
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
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?
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
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)
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