Filter Contains Integer In excel

Help
1

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
2

@kuih_sedap

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

Thanks :slight_smile:

3

Hi
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
4

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