Unable to delete columns in a datatable

j_bonnouvrier

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!

data.jmp

ms

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