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

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

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

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

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

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.

1 Like