nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

611966_en-US

liliconcom

How can I clear the contents of a specific column in a specific data table?

I have an existing data table and I've updated rows in it, but now I want to have a function that just clears all the rows or sets them all to empty(); also would like it to be really fast because it's a very large table. I tried this but it's quite slow.

	Column( my_table, "MY_COL" ) << formula (empty());
	Column( my_table, "MY_COL" ) << Delete Formula;

Advanced Statistical Modeling

Data Blending and Cleanup

Mass Customization

Quality and Process Engineering

Re: How can I clear the contents of a specific column in a specific data table?

Hi,

This should be faster; is it fast enough for your needs?

my_table[0, loc(my_table << get column names(string), "MY_COL")] = .;

For example:

Names Default To Here(1);

my_table = astable(J(1e5, 2, Random Uniform()));

my_table[0, loc(my_table << get column names(string), "Col1")] = .;