Is there any efficient way to set column names(with build datatable activity)

Help Studio
, , ,
1

Since there are hundreds of column names, is there any other efficient way to set column names when using the build data table activity, rather than manually entering each column name?

image

2

Hi @111962

You can try with below expression

(from P in DT1.Columns.Cast(of DataColumn)Select P.ColumnName).ToArray

DT1 → Your datatable
Regards
Gokul

1 Like
3

create a list / array of column names - colNameSet
create an empty datatable with myDT = new DataTable()
pass the colNameSet to a for each acitvity

  • create within the for each with the help of add DataColumn Activity the datacolumn and add it to myDt
1 Like
4

Hi,

Can you try to use GenerateDataTable activity with UseColumnHeader option?

If you have comma separated string data, the following will work.

img20211223-a1
img20211223-a11125×516 37.3 KB

If you have string array, the following will work.

img20211223-a2
img20211223-a21051×492 36.7 KB

Note: The above is assumed there is no special character in column name.

Regards,

1 Like
5

How is this datatable being populated? Unless you’re using Add Datarow, you don’t need to do Build Data Table first. Things like Read Range or data scraping will create the columns automatically.

1 Like
6

Hi, Thank you for your reply.

The reason for using build data table activity is to create a skeleton for the merge destination and later I want to merge multiple data tables at the back.
I also tried cloning the data table, but it didn’t work because those data table from which it was merged doesn’t have a header.

7

Merge Data Table doesn’t require Build Data Table to be used first to create the output table’s columns. It does that for you.

1 Like
8

Previously, I got an error because I couldn’t predefine the data table （Merge destination）to merge without using build data table activity.
I tried it again and it worked.
Thank you very much.

9

I didn’t know how to use this activity like this. thank you.
I’ll give it a try.

1 Like
10

Thank you very much.
I tried, it worked.

1 Like
11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.