Delete datarow

Help Studio
, ,
1

hi,
i have to write data of row where “Demono” is blank in another sheet & also delete data of that row where “Demono” is blank.

please find attached demo file.
HVInflow_RTGS_28032023 11_06_25.xlsx (11.4 KB)

2

Hey @Lakshya_Garg2

Please check this workflow and output excel file

DeleteRow.zip (1.9 KB)

HVInflow_RTGS_28032023 11_06_25.xlsx (14.0 KB)

Regards,

3

@Lakshya_Garg2

follow the steps

  1. Read the data from excel into datatable dt
  2. Now use filter datatble and give the demono column name and select is blankand select …output will be rows which are empty can paste in another sheet
    image
  3. Now use one more filter datatable and now select IsNotEmpty and it will give you all non empty…paste it back to same sheet

Use write range to write data

Hope this helps

cheers

4

hi,

this show invalid document

5

@Lakshya_Garg2

Please refer this screenshot

image
image528×569 28.6 KB

Filter data table wizard

image

Either you can use query or u can use filter data table activity.

Regards,

6

hi @Lakshya_Garg2

Please check the work flow and you can use it, :smiley:

Excel_Forum.zip (3.4 KB)

Regards,
Vasanth Kumar