Filter data and move data

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

image

Please guide me for solve it.

Thank you

Hi @Stef_99

Use Filter Data Table activity

Cheers!!

@lrtetala Ok, Filter for copy new sheet.

But how to delete row in original file?

@Stef_99

check the activity

@Stef_99

Can you try below

Regards,

Hi @Stef_99 ,

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

Keep:
image

Remove:
image

Workflow:

I hope that helps you.

Regards,
Vinit Mhatre

1 Like

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