Not able to do filter in it

Help
1

This is the following sample datatable,
image

not able to shot by “Day of Joinee”

2

Is that Database or Excel spreadsheet?
How are you trying to filter it?

3

In both i have tried

4

Can you upload the XLSX file ?

5

Data.xlsx (9.0 KB)

6

Problem is your formatting in Excel file.
You have :

Day
of
Joinee

Try to change it to : Day of Joinee

7

tamiltr.zip (8.5 KB)

Here, an example

8

Without changing it how we can process, did you change manually?

9

You can do it by column index, instead of row(“Day of Joinee”).ToString, make it row(1).ToString

1 Like
10

I just want to filter and need to save in the excel sheet without changing the column name

11

This one will do :slight_smile:

2 Likes
12

In this we can use only in message box, to see what data is available in data table but my question is how to filter it.

13

Alright, @tamiltr
So what we can do here is use Filter Data Table activity.
image
In the Column input box, enter the column index and configure your condition.

3 Likes
14

we can use that but there is space and it is like
“Day
of
Joinee”
if there is a space in it, we are not able to do filter using the Filter Data Table activity.
The trick in it is without manual correction we need to perform the filter operation.

15

image
As seen on the screenshot above, you can see that I used the index number of the column that I want to filter.

10 Likes
16

Is there is any other method

17

Hi
— hope we have the datatable ready in using read range activity and let’s name the datatable as outdt
— now use a assign activity like this to filter the date
outdt = outdt.Select(“[your Column name] < # “ + Now.AddDays(-3).ToString + “ # “ ]

We can make a condition based on our need
Hope this would help you
Cheers @tamiltr

18

@tamiltr
image

result:
image