How to remove and shuffle columns in a datatable

Help Studio
, ,
1

Hi All,
I have an excel sheet containing around 20+ columns and I need to remove around 4-5 columns from it with the data.
Than after this I need to shuffle the columns according to the table in datatable(excel containing the names of the columns is present and needs to be done once).
Also I have to add a column at last Named “processed_date” containing timestamp.
After this the final datatable has to be pushed to Database.
How to do it?

2

Assign yourDT = yourDT.DefaultView.ToTable(false,{“Column 1”,“Column 2”})

The {“Column 1”,“Column 2”} is an array of the columns you want to keep and their order.

3

RemovingData.xlsx (22.1 KB)
Hers is the excel sheet.
@supermanPunch @Gokul001 @ushu @kirankumar.mahanthi1 @Palaniyappan @Sudharsan_Ka @Anil_G
Can Anyone suggest something please?
Thanks in Advance!!

4

Hey @Kunal_Jain

I have a solution for you
Read the Excel sheet and then use the “Remove Data Column” Activity to remove columns
then you can write that datatable to excel and you will get your required output

Then push it into the database

5

@Vikas_M
How to remove multiple columns at a same time.
I have to remove around 5 columns from the above sheet I have given.

6

You can put those column names in an array or list and use for each activity
and insert “Remove data column” activity inside for each

7

@Kunal_Jain

Use filter datatable activity to remove your columns…in filter datatable you can go to columns tab and specify columns you need ot you want to remove anything

Then you can use add data column to add the rrquired column

Cheers