How to remove columns?

[pabaleloh]

I would like to remove columns i only need pay no, policy code and payment received. and save the excel file as csv. please assist

So i used this solution but some of the columns were not deleted

[pravallikapaluri]

Hi @pabaleloh

=> Read Range Workbook
Output → dt

=> Use below syntax in Assign:

Output_Dt = dt.DefaultView.ToTable(False,{"Pay No","Policy Code","Payment Received"})

Output_Dt is of system.data.datatable datatype.

=> Use Write CSV acitvity to write Output_Dt back to CSV.

Hope it helps!!

[pabaleloh]

@pravallikapaluri i have to remove the columns before i can upload the excel file…will this solution work for me?

[pravallikapaluri]

Hi @pabaleloh

Are you using Excel activities or Workbook activities?

Do you want to remove those columns from the original sheet?

Regards

[pabaleloh]

@pravallikapaluri Yes i want to remove them from original sheet i only need the 3 columns

[pravallikapaluri]

@pabaleloh
Please share the excel with dummy data

[ashokkarale]

@pabaleloh,

Follow this approach.

1. Define a array of string contains columns to be deleted.
   

2. Use For Each to iterate array of columns to be deleted.
   

   

3. Use Delete Column activity inside For Each to delete unwanted columns.

Full solution would look like this.

Thanks,
Ashok