How to filter the excel datatable?

Help
1

Hi all,

I am having an excel file . from this i want to filter column = customer.
from this column i want to filter only those rows having = Fujitsu
but there are some rows which has = Fujitsuｿﾌﾄｳｪｱ ---- i dont want this to be there in the output.
i did like this.
image

How to do only for - Fujitsu

Regards,
Seema

2

You can use “Sort Datatable” and list your sort criteria there

3

Of use a “For Each Row” to look for your sorted needs and output to another datatable

4

You can watch this session for complete understanding

1 Like
5

@Seema_S

Check as below

image
image1253×466 24.3 KB

Filter DataTable Activity

image

Mark as solution if this helps

Thanks

1 Like
6

we can also do this just as below:
image

Thank you all for your help

Regards,
Seema

1 Like
7

@Seema_S

If the Value is exactly same you need then it is fine, but if you need another string like 2nd row in my datatable i shown, then you need to use contains

Hope you understood

Thanks

1 Like
8

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