How to remove multiple column data

Help Automation Ops
,
1

How to remove only data in the multiple column but not headers of that columns.
How to remove the data from multiple columns

2

@anjani_priya

Hi

can you provide a sample input and expected output so that we can help

4

Book1.xlsx (10.5 KB)
name,age,salary column data should be removed but the headers should not remove

5

can you send sample code

6

@anjani_priya

image
image889×596 27.8 KB

Code:

For Each row As DataRow In inputDataTable.Rows
    row("Maths") = DBNull.Value
    row("Total") = DBNull.Value
Next
7

@anjani_priya

Try this

DT.AsEnumerable().ToList().ForEach(Sub(row) {
row(“ColumnName1”) = String.Empty
row(“ColumnName2”) = Nothing
row(“ColumnName3”) = DBNull.Value
})

8

@anjani_priya

dt2_Updated.AsEnumerable.Select(Function(r) dt2_Updated.Clone.LoadDataRow({“”,“”,“”,r(3).ToString,r(4).ToString},False)).CopyToDataTable

use this in assign activity

and use write range activity

9

@anjani_priya

image
image889×596 25.8 KB

Code:

For Each row As DataRow In inputDataTable.Rows
    row("age") = DBNull.Value
    row("BRANCH") = DBNull.Value
Next

O/P:
Book1 (4).xlsx (10.4 KB)

Please find the below xaml for your input excel file

BlankProcess12.zip (129.9 KB)

Hope this helps!!

10

without write range it will work?
because I dont want to write the data in another sheet just it should remove the data in the current sheet

11

image
image545×671 28 KB

image
image1046×320 12.3 KB

code to write in invoke code is
dt_Sample.AsEnumerable.ToList.ForEach(Sub(x)
x(“name”)=Nothing
x(“age”)=Nothing
x(“salary”)=Nothing
End Sub
)

12

@anjani_priya

It writes within current sheet please look into this

for arguments passing please find below image

image
image1038×698 31.1 KB

13

Capture4
Capture41431×494 29.5 KB

error

14

@anjani_priya

Are you passing the arguments correctly please check

image
image1038×698 31.1 KB

15

Capture5
Capture51018×616 23.4 KB

see this
I have created the variable as “data”.

16

@anjani_priya

dt2_Updated.AsEnumerable.Select(Function(r) dt2_Updated.Clone.LoadDataRow({“”,“”,“”,r(3).ToString,r(4).ToString},False)).CopyToDataTable

Sequence1.xaml (7.8 KB)

17

The changes should be done in the same sheet

18

iam getting an error

19

@anjani_priya

It is working perfectly in my PC

Please try this xaml

BlankProcess12.zip (134.6 KB)

20

@anjani_priya

Can you show that error

21