Remove data column more than 1 column name?

[fairymemay (noona)]

I want to remove data column more than 1 column name.

But show error.

How to edit it.?

[Shikhar_Tandon]

Use two different activities to remove the columns.

Thanks

[Palaniyappan (Forum Leader)]

Hi

There are two ways to do this

If you know if it’s only two column then it can’t be mention in one single activity

In that case use two activities one after the another

Or

If you have less number of columns and if you want to remove these two columns then mention only the column you want in the below expression

this expression in assign activity

dt = dt.DefaultView.ToTable(False, “ColumnName-1”, “ColumnName-2”,….,”ColumnName-N”)

This will give only the columns you want

Cheers @fairymemay

[Gokul001 (Gokul Balaji)]

(post deleted by author)

[liu_shubin (Shubin)]

There are many ways to remove columns from data table. One of the methods is using activity “Filter Data Table” to remove specified columns. You can refer to the screenshot below.