topic Unable to delete columns in a datatable in Discussions

Unable to delete columns in a datatable

j_bonnouvrier — Fri, 13 Jan 2017 08:21:16 GMT

Good morning,

I am currently writing a script in order to extract data from an Excel file and format the data table.

A typical exemple is enclosed to this post.

My concern is that I cannot delete the last columns (6th column to the end). Do you have any clue on what the problem is?

Thanks in advance for your help!

Re: Unable to delete columns in a datatable

ms — Fri, 13 Jan 2017 10:05:16 GMT

Deleting columns changes the dimensions of the table which can cause a forward going loop to fail. Try to delete from the end.

dt = Current Data Table();
n = N Col(dt);
// Delete last six columns columns, starting from the end
For(i = n, i > n - 6, i--,
    dt << delete columns(Column(i))
);

// This should also work: delete very last column six times
For(i = 1, i <= 6, i++,
    dt << delete columns(Column(N Col(dt)))
);

Re: Unable to delete columns in a datatable

j_bonnouvrier — Fri, 13 Jan 2017 10:07:28 GMT

Problem fixed, thanks!