If current datarow contains "A", then delete next datarow if it is blank

[Suastrian_Dika (Dika)]

from

to

[arjunshenoy]

Hi @Suastrian_Dika

Can you please confirm if you are looking to delete the row where the data column is empty? Is this your requirement?

Best Regards.

[Suastrian_Dika (Dika)]

yes @arjunshenoy

[Suastrian_Dika (Dika)]

if current datarow contains “A”, then delete next datarow if it is empty/blank @arjunshenoy

[arjunshenoy]

@Suastrian_Dika

You can use the following query to skip such rows from the datatable:

dt.AsEnumerable.Skipwhile(Function(row) string.IsNullorEmpty(row(“Data”).ToString)).CopyToDatatable

Here, dt will be your datatable & this query will discard the rows where data column is empty.

Hope this helps,
Best Regards.

[arjunshenoy]

@Suastrian_Dika

You can design your workflow like this:

Input:

Output:

Hope this helps,
Best Regards.

[Suraj_B_Shetty (Suraj)]

Hi @Suastrian_Dika

Check this wokflow. It matches your requirement.
DeleteNextRow.xaml (11.8 KB)

Input

Output

Hope this helps.