I used the filter from excel 1 to excel 2, but somehow it is not working. Could you please kindly help?

Help
1

I used the filter from excel 1 to excel 2, but somehow it is not working. Could you please kindly help?

image
image1163×516 31.9 KB

I want to filter all types except WI5. Please kindly help. thanks.

2

@vivianlam12 can u share what condition ur giving in the workflow?

3

@Manjuts90 Thanks so much for your reply. Please see the details below and let me know if further information is needed.

I wanted to filter the data “type” in the excel (WI1, WI2, WI3, WI4) and save to another excel sheet. I followed the video on the filtering motor tutorial, but it doesnt work. The sheet 2 still have all types. Please see the screen captures. Thanks.

image

4

@vivianlam12 can u share the filter statement?

5

what is your select statement.?

6

Hi @vivianlam12,

I hope you are reading the excel1 and storing it in a datatable. Then you can use filterTable activity to filter on rows or columns whatever you want.
If you want to filter WI5(Assuming it is a row value), then you can add like this

image

Hope it helps.

Regards,
Hareesh