Delete Column

[MD_Farhan1 (MD Farhan)]

Hi,
I want delete Particular column using column name is (“Actual Profit %”,“Expected Profit %”).
Thanks and Regards…

[lrtetala (Lakshman Reddy)]

Hi @MD_Farhan1

Use Remove Data Column activity

[vrdabberu (Varunraj Dabberu)]

Hi @MD_Farhan1

Use the remove column activity and pass the column name and the data table name that you want to delete from

Regards

[pravallikapaluri]

@MD_Farhan1

Actual Profit %”,“Expected Profit %

Hi @MD_Farhan1

Hope it helps!!

[rlgandu (Rajyalakshmi Gandu)]

@MD_Farhan1

filteredDataTable = YourDataTable.Clone() ’ Create a copy of the original DataTable structure
filteredDataTable.Columns.Remove(“Actual Profit %”)
filteredDataTable.Columns.Remove(“Expected Profit %”)

[Steven_McKeering]

Hey @MD_Farhan1

Check this Datatable post for various datatable actions explained:

All about Datatable - UiPath

Hi All, Datatable - variable type is the most commonly used variable type by all UiPath users And it’s been the most often asked queries in forum especially on its manipulation So I would like to have this post as a repository for those who are looking for expressions related to Datatable Let’s go one by one keeping dt as name of datatable variable 1. Get number of rows in a datatable dt dt.Rows.Count (output - int32 type) 2. Get number of columns in a datatable dt dt.Columns.Count (output…

Cheers

Steve

[MD_Farhan1 (MD Farhan)]

I Got above error…

[pravallikapaluri]

@MD_Farhan1
Can you send snippet of the activity you used.

[vrdabberu (Varunraj Dabberu)]

Hi @MD_Farhan1

I hope you have given both the column names in the same activity.

Remove data column works only for a single column at a time so if you want to remove 2 columns then please use 2 remove data column activities and that works!!

Regards

[vrdabberu (Varunraj Dabberu)]

Hi @MD_Farhan1

Thank You

Happy Automation!!

[MD_Farhan1 (MD Farhan)]

Hi,

I Delete one column . then i delete second column is got error.

Regards.

[vrdabberu (Varunraj Dabberu)]

Can you send the screenshot of the flow after first Remove Data Column activity @MD_Farhan1

Regards

[MD_Farhan1 (MD Farhan)]

This is my flow.

[vrdabberu (Varunraj Dabberu)]

HI @MD_Farhan1

I hope the excel contains 2 columns with the same column name so that’s the reason this error is being arised. Please check in you excel sheet.

Regards

[vrdabberu (Varunraj Dabberu)]

Hi @MD_Farhan1

After single read range activity you can directly use the remove data column activities as shown below and after removing both the columns you can directly write the data table to excel as shown below

Regards

[MD_Farhan1 (MD Farhan)]

Hi,
Before Remove Column look live below

After Remove Column Look Like Below

Below My WorkFlow

[vrdabberu (Varunraj Dabberu)]

Hi @MD_Farhan1

->Don’t use that many Write Range Activity.
->First you complete all the operations that need to be done on that data tables and at last you use the write range activity.

Regards

[MD_Farhan1 (MD Farhan)]

still not delete come with last column.

[vrdabberu (Varunraj Dabberu)]

Hi @MD_Farhan1

Can you share the workflow and the Input Excels so that I will provide you with the changes that required.

Regards