How to append a string to all column headers in dt

Help Activities
, ,
1

Dear all,
I need help in adding a string to all column headers in a datable
Example:
Header:
Location, City,Country

i need to append “Select.” to all the headers
output should look like
Select.Location, Select.City, Select.Country

please help

2

Use a for each loop:

For each item in DT.Columns
Assign
str = str+“;”+“Select.”+item.ColumnName

Now use a Generate DT with str as ColumnNames, pass it in Input and Column Separator as “;”

This will Generate a DT with required columns.

3

Check this below workflow, @ashwini.bagewadi
Uipath_AddStringToHeaders.xaml (5.8 KB) and I have used below query to do that - String.Join(“,”,InputDt.Columns.Cast(Of System.Data.DataColumn).Select(Function(x) “Select.”+x.ColumnName.ToString).ToArray())
Hope this may help you :slight_smile:

1 Like
4

Thank you so much for answering to my question. I tried to execute as your advice, but have a doubt, what is .ColumnName at the end of str assign? is it the header column name like “Location”? I have a datatable with header names :Location, City,Country along with its contents, and want to create a new datatable with changed headers along with its contents. It will be really helpful if you solve this doubt

5

@ashwini.bagewadi Yes. .ColumnName at the endof str assign gives the value “location”. It fetches all headers in a for each loop and appends them to the str and later uses the separator to split the string and use new headers as Select.ColumnName

6

Thank you so much @Manish540 for your answer, that did give me an output, but it is giving me headers in string format, and i need the headers in datatable format

7

Compiler error(s) encountered processing expression “str+”;“+“Select.”+item.ColumnName”.
Option Strict On disallows late binding.
I getting the above error for the assign.

8

If you just need to rename the headers (the column names), you can do so in the For Each Loop:

col.ColumnName = "Select." + col.ColumnName

image

image

image

2 Likes
9

This is great :smiley:. It totally worked. Thank you soo much @ptrobot

1 Like
10

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