Data Table Loop Through Columns and Rename each column

Help
1

I have a data table with unnamed columns. How do I loop through each column and add a name to each column?

I tried using a for each loop to iterate through DataColumns but I get error Option Strict On disallows implicit conversions from System.Data.DataTable to System.Collections.IEnumerable

2

Try this -

columnCount = myDataTable.Columns.Count
For Each index in columnCount
{
     myDataTable.Columns(0).ColumnName = "newColumnName"
}
1 Like
3

Currently doing this in For Each activity, I get error Value of type Integer cannot be converted to System.Collections.IEnumerable

1 Like
4

renamecolumn.xaml (8.2 KB)

This shows you the way to do it. You can come up with different ways to provide the new column names but this simple example should help. The output of this example looks like:

image

A simple table of names and ages. I changed Column2 to “Names” using the workflow

5

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