Unable to delete columns in a datatable

[#1]

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!

[#2 · Accepted solution]

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)))
);

[#3]

Problem fixed, thanks!