Delete column by scipt

Dennisbur — Thu, 08 Jun 2023 16:39:46 GMT

Hello

I have written a script for deleting the column "Missing(Result)" in the table

My problem is that sometimes I do not have the column "Missing(Result)" and I'm receiving an error at this moment.

Can you assist me with what I need to add to my script that will delete the column if it exists in my table.

And if it doesn't exist, just skip this request?

dt << delete column (column ("Missing(Result)"));

Re: Delete column by scipt

jthi — Mon, 30 Jan 2023 17:41:12 GMT

Use << Get Column Names(String) to get list of column names and then if statement with Contains to check for the specific name

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
col_names = dt << Get Column Names(String);

If(Contains(col_names, "Missing(Result)"),
	dt << Delete Columns("Missing(Result)")
);

topic Re: Delete column by scipt in Discussions

Delete column by scipt

Re: Delete column by scipt