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()
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
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
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
tttt.xaml (23.0 KB)
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.
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
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?
@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.
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)
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.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.