Edit filter day

Help Activities
, ,
1

I want edit filter from 2 days to read value in input dialog.
Please guide me about it.

image

2

Hi @fairymemay

I am not cleared with ur point

Can u share the screenshot of input and output of datatable u need

3

@NIVED_NAMBIAR

Input
image

I want to filter day in column E by user input value day

image

Example if I key input dialog 4.
I want to send value=4 replace 2 in assign dtOutput.

Please guide me about it.

4

Can you send the sample excel file? @fairymemay

5

Hi @fairymemay

Please find the attached xaml file for your reference. Feel free to reach me if you have any doubt. Thanks.
Main.xaml (8.0 KB)

6

Hi @fairymemay
Try using this buddy

dt1 = dt1.AsEnumerable().Where(Function(row) row(4).ToString.Contains(day_var+“days”)).CopyToDataTable

where day_var is the input u are giving

Mark it as solution if it resolves your query

Regards
Nived N
Happy Automation

7

what he is asking nived can you explain

8

@fairymemay needed to filter the column E with the dynamic value that user inputs

Hope u got the idea @copy_writes

1 Like
9

@NIVED_NAMBIAR I try follow your suggest.
But If I day_var = 2
dt1 filter 4days , 54days and 84days
I want output 4days only.

image

Please guide me about it.

10

dt1 = dt1.AsEnumerable().Where(Function(row) row(4).ToString.Equals(day_var+“days”)).CopyToDataTable Try this @fairymemay

I acccidently added the contains instead of Equals

Check this workflow sample workflow.zip (2.0 MB)

Regards
Nived N
Happy Automation