I have a table like this [image] What I need to do is I need to fetch the whole row in excel wherever the date 18 May is appearing PS. Table has no headers to it Any Suggestions ?

if you dont want additional columns, assign filteredDt = dt.AsEnumerable.Where(function(row) cdate(row("Column1").ToString).Day = 18 and cdate(row("Column1").ToString).Month = 5).CopyToDataTable

in general it is a filter task on Excel / Datatable after read range for missing headers we can use the column index in case of datatable

Exactly. Can You provide me a solution to this ?

Try this with an Assign activity: dtFiltered = (From i In {0} Let matchingRows = dt.AsEnumerable.Where(Function(r) r(1).ToString.Trim.StartsWith("18 May")) Select If (matchingRows.Count > 0, matchingRows.CopyToDataTable, dt.Clone) ).First [image]

add 2 columns, Day and Month column then assign Day = day of 2nd column assign month = month of 2nd column then filter datatable where day=18, month=5 testt.xaml (9.5 KB)

[Screenshot (105)] Getting output like this.

That seems to be just the headers (i.e. no matching rows). Is the date not always in the second column?

No it’s not, I have Multiple date columns

If the date can be in any column, then the expression should be: (From i In {0} Let matchingRows = dt.AsEnumerable.Where(Function(r) r.ItemArray.Any(Function(x) x.ToString.Trim.StartsWith("18 May")) ) Select If (matchingRows.Count > 0, matchingRows.CopyToDataTable, dt.Clone) ).First

Well I got the Output with this Only thing is I don’t want the time (00:00:00) in this. [image] Also What If My date column is random. So what code should I put in that case ?

Retrieving Whole Row Data using Specific Cell data in Excel

Help Robot

Rahul_Unnikrishnan (Rahul Unnikrishnan) May 4, 2022, 11:08am 11

Hello @Ishan_Shelke1 ,

You can do as below. WHile using read range disable “Has Header”.

Topic		Replies	Views
Random Date Column Records Retrieval Robot robot , question	3	651	May 20, 2022
How to get a specific row Help robot	9	3689	October 29, 2018
How to find a specific string in a dataTable with query Reboot Your Skills 2021 week-4	6	1331	June 17, 2021
Filter date inside same column into datatable Activities excel , activities , question	7	701	June 2, 2022
Extract datatable excel Help	14	2068	September 11, 2019

Retrieving Whole Row Data using Specific Cell data in Excel

Related topics