Hi All,
I need to filter column in excel where I want to filter column “courseNumber” which starts with 1013 and save it into another CSV…here is the screenshot of Excel…Quick suggestion and reply would really help.
Thanks,
Somya
Hi All,
I need to filter column in excel where I want to filter column “courseNumber” which starts with 1013 and save it into another CSV…here is the screenshot of Excel…Quick suggestion and reply would really help.
Thanks,
Somya
Hi,
Here i have attached the sample for filtering column in Excel
File : Filtering Column in Excel.zip (13.5 KB)
Thank you
Balamurugan.S
@somya177
First Read your excel sheet and store it in a datatable variable dt
Then try this query and Assign the result to datatable dtb
dtb=(From p in dt.select()
where Convert.Tostring(p.Item(“COURSE_Number”)).startsWith(“1013”)
Select p).ToArray.CopyToDataTable
Regards,
Mahesh
Hi @somya177,
Using Read range activity to get the data to Data Table (Dt)
use assign activity to filter the data
Dt=Dt.Select("COURSE_NUMBER like '1013%' ").CopyToDataTable()
use write range to write the data into another excel file.
Regards,
Arivu