Hi there, I use filter datatable to remove rows I don’t need. but always can’t get the result. I need final data contains ORG A and B, request date less than 2021-01-01, and COMP_STAT is not Unbooked. Main.xaml (9.9 KB) File1.xlsx (20.6 KB)

@learningRPA Ohh Sorry. There is a Minor change that you need to do in the Linq Query in the First Assign Activity. You would need to add a NOT as shown below : [Capture] Let me know if it doesn’t work. Introduction to Linq and it’s operations and it’s uses might be useful for future references …

Failed to get data on filter datatable

Learn Academy Feedback

supermanPunch (Arpan) August 15, 2020, 6:56am 2

@learningRPA Check this workflow :
FilterDT.zip (13.0 KB)

I used Linq queries to get the required output, as I don’t think the date Comparison works well with Filter Datatable.

1 Like

Filtering datatable 'DateTime' type using 'xxxx.Select()' method

Topic		Replies	Views
Filtering datatable 'DateTime' type using 'xxxx.Select()' method Studio datatable , activities , feedback	2	1067	August 20, 2020
Filter Data Table from excel Studio studio , question , template	10	361	September 16, 2023
Linq Query to filter datatable Date Column Something Else feedback	4	5045	September 16, 2021
Filter data table with dates Activities excel , activities , studio , question	13	772	July 13, 2023
CertificationExam_filterDate Help datatable , activities , question	4	792	December 17, 2019

Most Active Users - Yesterday
Anil_G
ashokkarale
jinal.shah
Gautham_Pattabiraman
postwick
chandreshsinh.jadeja
vrdabberu
Ajay_Mishra
sven.wullum1
Vyshnavi_Nalumachu
More details...

Failed to get data on filter datatable

Related Topics