Filter data and move data

[Stef_99 (Mary)]

I have data as below.

In sheet1 I want cut data row that column Check_1 = N , Check_2 = Y and Check_3 = N to new sheet (sheet name copy) and have same header

Please guide me for solve it.

Thank you

[lrtetala (Lakshman Reddy)]

Hi @Stef_99

Use Filter Data Table activity

Cheers!!

[Stef_99 (Mary)]

@lrtetala Ok, Filter for copy new sheet.

But how to delete row in original file?

[Krishna_Raj]

@Stef_99

Activities - Delete Rows

check the activity

[lrtetala (Lakshman Reddy)]

@Stef_99

how to delete row in original file?

@Stef_99

Can you try below

Regards,

[Vinit_Mhatre (BotBuilder)]

Hi @Stef_99 ,

You can do it as follows: Take two filter activities, one for keeping the row and one for removing it.

Keep:

Remove:

Workflow:

I hope that helps you.

Regards,
Vinit Mhatre