Printing Specific Columns

[Ishan_Shelke1 (Ishan Shelke)]

Apple	Fruit	18-Apr-2022
Banana	Fruit	18-Apr-2022
Guava	Fruit	19-Apr-2022
Capsicum	Vegetable	19-Apr-2022
Cauliflower	Vegetable	20-Apr-2022

How to retrieve whole column where Date is 18-Apr-2022.

[ppr (Peter Preuss)]

Give a try at:

Assign Activity:
LHS: dtFiltered |Datatype: dtFiltered
RHS:

(From d in YourDataTableVar.AsEnumerable
Where CDate(d(2).toString.Trim).Date = new DateTime(2022,4,18).Date
Select r=d).CopyToDataTable

For Adoptions and further analysis have a look here:

[FirstAid] Handling of The source contains no DataRows exception

This FirstAid Tutorial will describe how a the source contains no DataRows EXCEPTION can be handled. Introduction Let’s have a look at the following filter data table scenario: Name CCode Tom US Charlotte FR Seema IN Jean FR Assignment: Filter all rows on a particular Country Code like FR, UK, ES, UK… Ensure that all CCode data column values are trimmed Ensure that the Filter check is case insensitive we can implement it e.g. with the help of a LINQ statement: dtData.As…

[FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues

This FirstAid Tutorial will describe how DateTime parsing issues can be analyzed and handled. Click spoiler text when in hurry: Example Assignment Following Excel data will be processed and the corresponding Quarter is to calculate for the particular task date Input data: [input_raw] Quarter Calculation Quarter = CInt(Math.Ceiling(YourDateTimeVar.Month / 3 )) Initial Implementation [initial_flow_raw] tmpTaskDate = DateTime.ParseExact(row("Date").toString.Trim, "dd.MM.yyyy", Culture…

[ushu (Usha kiranmai)]

@Ishan_Shelke1 You mean you want to select the row whose date is 18-Apr-2022

[Ishan_Shelke1 (Ishan Shelke)]

Yes I want to print those rows where date is 18-Apr-2022

[ushu (Usha kiranmai)]

@Ishan_Shelke1 Try this workflow

Example.zip (9.8 KB)

Input

Output