844099_en-US

liliconcom

Enable Columns Manager (v18) to change multiple columns modeling or data type at once

What inspired this wish list request?  When first loading a messy file, e.g. a log file, often the columns all end up as "character" type because there are some text-lines inserted into the data.  After removing them, the next step is to configure all of the numeric columns' data and modeling types.  Doing this with Standardize Attributes takes a lot of mouse clicks, but the new Columns Manager is a much more intuitive interface for making these types of corrections.

 

What is the improvement you would like to see?    CM, however, doesn't allow you to select multiple rows and change the data or modeling types -- as soon as you try to click the drop-down arrow, it deselects all other rows.  So this request is to allow changing data and modeling types on multiple selected rows within Columns Manager with a single change on any of the rows.

 

Why is this idea important?  It makes the intuitive action possible.

 

Data Blending and CleanupRe: Enable Columns Manager (v18) to change multiple columns modeling or data type at once

agree, for "Format" the described functionality is already available:

 

Re: Enable Columns Manager (v18) to change multiple columns modeling or data type at once

Turns out there's a trick to this, at least on the Mac -- if you select all the rows to be changed, then cmd-click on the gray-triangle in the "Type" column, it will let you change them all at once.

Re: Enable Columns Manager (v18) to change multiple columns modeling or data type at once

Thanks

Re: Enable Columns Manager (v18) to change multiple columns modeling or data type at once

really excited - I should add it to  CTRL/Alt/Shift + click/select/double click/right click  ...
Ooops:


Hm, I already know this feeling. Not the first time ....

Re: Enable Columns Manager (v18) to change multiple columns modeling or data type at once - Status changed to: Acknowledged

Thank you for submitting your request and sharing an update on how to accomplish it. Your feedback is valuable, and we'll keep it in mind for future improvements. For now, we're glad you found a way to achieve your goal!