How to reorder or hide the columns of a dataset

In many cases, you might want to reorder the columns of a dataset. In other situations, you might just want to temporarily hide columns from view. Both actions can easily be achieved with Dataiku DSS.

Reorder Columns

In a Prepare recipe (or a Visual Analysis in the Lab), use the Move columns processor to alter the order of columns. This processor can be implemented by adding a new step from the processor library. Or more easily, by manually clicking on a column name and dragging it to the desired position. With large numbers of columns, switching from the default table view to the columns view often makes dragging columns even easier.

Hide Columns

Instead of changing the order of columns, you may just want to temporarily hide certain columns or select which ones to view. When viewing any dataset, use the Display dropdown menu towards the top right corner and choose Select displayed columns. Then you can choose to display all columns, or a specific subset of columns, without affecting the actual dataset.

../../_images/kb-reorder-columns-display.png

Another tool to quickly find a particular column is to press the “C” key while viewing a dataset. Doing so opens a column spotlight search. Enter a column name to ensure that it is included in the view of currently displayed columns.

../../_images/kb-reorder-columns-c.png

What’s next?

Visit the Dataiku Academy for a number of hands-on tutorials on visual data wrangling with Dataiku DSS.