Add column in data table relative to another column

[gary.cobden]

I have a data table in an excel spreadsheet with column headers. I need to insert a coulumn immediately after one of the existing columns in the data table.

There is the potential that the column positions in the excel spreadsheet/data table may change, but I want to prevent having to recode if that is possible

As an example I have a data table with e-mail address (at column 4) and need to insert a blank column after the e-mail address (at column 5)
If the underlying data that produces that data table changes, and the e-mail address is now at column 3, I need to be able to insert my new column at column 4 (after e-mail address) and not at column 5

Thanks for your assistance

[william.coulson (Will Coulson)]

Hi @gary.cobden,

If your column have names and are consistent, you might be able to use that to get the position of the column.

The topic below has a solution but it is C#.

Retrieve position of specific column name

Is there a way to retrieve the position of a specified column name? I tried using lookup datatable and referring to the example xaml file provided on the main site but fail to achieve my goals as I just need to find the position based on a specified column name. Any advise will be appreciated