Values of a column in an excel sheet to be stored into an array

@vicky1234567890,

Try with the following code in an assign activity with a string array variable

raw.Rows.Cast(Of DataRow)().[Select](Function(row) row("Cust Code")).ToArray()

if condition is also working sir, but i am unable to filter the table using that string. please help me out of this

how to assign this array to filter data table one after another after using this
raw.Rows.Cast(Of DataRow)().[Select](Function(row) row(“Cust Code”)).ToArray()

if i assign a string directly it’s working, but if i assign a variable it is unable to filter

@vicky1234567890,

How you are filtering datatable with this array?

ppp.xlsx (9.3 KB)

i want to filter data of this kind. i had a lot of data like that. i want to follow the following steps

  1. unique values of the Cust Code(column) should be stored
  2. compare that unique CuSt COde with the data in my excel
  3. then filtering the data of respective cust codes

ppp.xlsx (9.2 KB)

i need this as output.
like the above sheet i want all the custcodes to be filtered seperately and store in another excel sheet




please go through my workf;ow and help me out of this @sarathi125

tttt.xaml (16.8 KB)

please help me out of this @sarathi125

tttt.xaml (23.0 KB)

@vicky1234567890,

Check with this one, for each unique custcode the master table will be filtered and a new mail will be triggered with the filtered data in an excel file.

1 Like

tq very much @sarathi125. i need another help.
I have two excel sheets.
I want to copy the 2nd row of one excel sheet and make it as 1st row of other excel sheet.
please help me out of this. @sarathi125

@vicky1234567890,

Do you have any existing rows in the second excel?

Is this one time activity or dynamically you want the 2nd row from the first excel to the 1st row in the second excel?

1 Like

@sarathi125 thakyou for your quick response.
yes, i have existing rows in my second excel sheet
I want to add row dynamically

can i know how to get the 2nd row of 1st sheet into one data table. than i can merge those two tables.

1 Like

@vicky1234567890,

Check this xaml, you will get the datarow from a datatable using its index value. So you can merge that into the destination table as you want.

GetRowFromDataTableUsingIndex.xaml (7.8 KB)

2 Likes

i want to copy folders from cloud data and paste it on my desktop by creating new folder.
please help me out of this @sarathi125.

@sarathi125 can you help me out of this

@vicky1234567890,

You can refer this,

sorry, I couldn’t find it. could you please suggest me some more.
thank you @sarathi125

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