How to delete row with if condition

Help Community
,
1

Hello guys i want to ask, how can we delete the entire row if the row have value in specific column?

Example i have data with 3 colums, there is
Name Email Phone.

If the row have value in phone column, i want to delete that entire row.

2

Hi,

For now, can you try FilterDataTable activity? We can remove rows based specific condition, as the following.

image

Regards,

3

Hello @Yoichi , i tried this way but im having an issue like this.

I have 3 rows data like this

Name Email Phone
John John@
Doe Doe@ 72414
Rick rick@

When i tried to filter using filter database activity, the data change to this
Name Email Phone
John John@
Rick rick@
Rick rick@

The third row duplicate to the second row, idk why. Do u know why it can be happen like that?

4

Hi,

It’s because previous row of Rick rick remains. Please delete all the rows before Write the filtered datatable to the sheet. ( Or write it to new sheet (template) then replace it)

Regards,

5

Ah okay i see, its worked thank u so much @Yoichi, appreciated it :smiley:

1 Like
6

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