Hi all, I am facing difficulties during the use of Datatables. I have got a huge excel table with more than 80000 rows. I have to remove specific rows from that Excel. Every row which contains the word 2022 1Q and 2022 2Q and 2022 3Q and 2022 4Q should be removed from the Excel. I am first reading …

[image] MaryspaceX: 2022 1Q 2022 2Q 2022 3Q and 2022 4Q Try with this expression You need to use a assign activity DT_Result = the below expression Dt1.AsEnumerable().Where(Function(s) Not "2022 1Q,2022 2Q,2022 3Q,2022 4Q".Contains(s(0).ToString)).CopyToDataTable Dt_Result will have the d…

Remove rows with specific words from datatable

Help Activities

MaryspaceX (MaryspaceX) January 6, 2023, 1:30pm 13

Hi @Sudharsan_Ka

One last question:

How can I replace “2022 1Q,2022 2Q,2022 3Q,2022 4Q” with variables e.g fiscal Year is a Varibale assigned before in the process: fiscalYear + " " + “1Q”, fiscalYear + " "+ “2Q”?

Topic		Replies	Views
Filter excel table to remove particular rows Help datatable , activities , question	15	3682	June 13, 2024
I have to delete a particular row Activities datatable , excel , activities , studio , question	5	665	April 26, 2022
How to remove row with specific entire row based on condition Activities datatable , excel , uiautomation , activities	5	406	October 27, 2023
Deleting rows in a Data Table Studio studio , question , activities_panel	9	4664	April 21, 2022
Remove Row in Excel with Particular Date Studio	6	975	September 28, 2022

Remove rows with specific words from datatable

Related topics