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

Help Studio
, , ,
1

from

image

to

image

2

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.

3

yes @arjunshenoy

1 Like
4

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

5

@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.

6

@Suastrian_Dika

You can design your workflow like this:

image

Input:

image

Output:

image

Hope this helps,
Best Regards.

7

Hi @Suastrian_Dika

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

Input
image

Output
image

Hope this helps.

2 Likes
8

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