Edit Data Definition to remove first row and add ' in header

Help
1

Hi, I am extracting a datatable but would like to remove 1st row from the result as well as change the name of one of the header to include a " ’ （apostrophe)" in it.

The 1st row which looks similar to the header should be removed
Column “Intl Rating” should actually be “Int’l Rating” in the screencap

image
image661×675 31.5 KB

2

You could just edit the resulting datatable, that is, rename column:

myDataTable.Columns(0).ColumnName = “newColumnName”

And then remove the first row, just by copying over the existing datatable with a new one, skipping one row. Use this in an assign activity:

DataTable_Variable.AsEnumerable.Skip(1).CopyToDataTable

3

myDataTable.Columns(0).ColumnName = “newColumnName”

Is this need to be done as a Assign Activity ?? If Yes then what is the Variable Type ??

1 Like
4

Hi @smanik19

Yes, it should be the Assign activity.

You are assigning the string “newColumnName” to a column name. The column and its name is part of the data table myDataTable.

2 Likes