Remove only column names from datatable without removing the data

[stanstilo (stanley)]

Hi devs, pls anyone with logic to only remove the column names from datatable without removing datatable.Remove datatable activity will not work here cause I don’t want to remove data with the columns just the columnnames.Regards

[postwick (Paul Ostwick)]

What do you mean remove the column names? Columns must have names.

[ppr (Peter Preuss)]

A datatable has internally DataColumns. DataColumns do have names. This internally structure we do not touch.

Maybe you elaborate on the motivation why the columns should be dropped

[stanstilo (stanley)]

Would like remove all these column names so as to append to another datatable

[GouthamVijay]

Hi @stanstilo ,

You can use Filter DataTable for removing columns.

[ppr (Peter Preuss)]

@stanstilo

as to append to another datatable

we can merge two datatables with the merge datatable activity. Ensure that it will have the same columnstructure (and also names - otherwise rename it)

On excel base we use append range or write range without addHeaders option

when columnnames are part of the datatable (e.g. first row) we remove the first row e.g. remove datarow activity

[Gokul001 (Gokul Balaji)]

HI @stanstilo

You can try with Merge Data Table activity

Merge Data Table

Regards
Gokul

[Gokul001 (Gokul Balaji)]

HI @stanstilo

Some thing like this

Dt1 structure look like this

Dt2 structure look like this

Merge Data Table

Output

Regards
Gokul

[stanstilo (stanley)]

In some cases, the columns will not have the same columnstructure, in such case what should be the workaround please

[ppr (Peter Preuss)]

@stanstilo

he columns will not have the same columnstructure, in such case what should be the workaround please

harmonizing .e.g renaming / removing unneeded cols.

We gave you some building block above. Before resulting in a long ping pong thread:

share sample data
share expected output

[stanstilo (stanley)]

dt1 - Name Age Status
mark 20 pending
smith 22 completed
mary 15 pending

dt2 - Name Age Status Amount Comment
George 13 completed 400 Airbag purchase
Jamain 33 pending 200 Grocery

Output - mark 20 pending
smith 22 completed
mary 15 pending
George 13 completed 400 Airbag purchase
Jamain 33 pending 200 Grocery

[Gokul001 (Gokul Balaji)]

HI @stanstilo

You can try with Merge Data Table

Check out the Sample XAML file

Common&UnCommon.xaml (13.4 KB)

Regards
Gokul

[stanstilo (stanley)]

Alright thanks Devs for your contributions. Regards

[Gokul001 (Gokul Balaji)]

@Gokul001

Check out the Sample XAML file

Common&UnCommon.xaml (13.4 KB)

Have you checked this XAML file? @stanstilo Have you got the output?

If yes, Kindly close this topic by mark as solved

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has fo…

Regards
Gokul

[postwick (Paul Ostwick)]

Rename the columns so they match.