Filter Contains Integer In excel

Untitled I need to filter all data start from year2020 in column "planned start ",why i cant use filter data table activity?“planned start” CONTAINS 2020,Is that Wrong?

1 Like


Using filter table is correct.
Have you given so??

Thanks :slight_smile:

Did we try with a Assign activity like this
datatable = datatable.AsEnumerable().Select(Function(a) a.Field(of string)(“yourcolumnname”).ToString.Contains(“2020”)).CopyToDatatable()

Cheers @kuih_sedap

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.