cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Choose Language Hide Translation Bar
Standardize Attributes

 

If you've every wanted to alter the attributes or properties of multiple columns like change the Data Type from Numeric to Continuous, there is a quick way to change the properties of all columns in one interactive window.

 

First Select the columns you want to change, then From the Columns Menu or by right-clicking one of the Column headers. and choose "Standardize Attributes"

 

In this window you can change options for multiple columns.

Here, I have 4 four selected in this SAT sample data.

 

At the top of the window we can Recode these Column Values collectively.

 

We can Standardize Attributes like changing the Data Type of all four of these Columns to Numeric.

And Under Standardize Properties, I can add an identical Formula to all of the Columns selected.

 

I imagine if you had a wide data table with let say 200 Columns, this would be a huge timesaver.

 

Try this now by selecting multiple columns and right-clicking Standardize Attributes.

 



Recommended Articles