Rearrange, Hide, and Delete Columns in the Data & Insights Data Management Experience


Note: Schema changes may change the derived views based on a dataset, either preventing them from displaying or changing their meaning. When you make schema changes to a dataset which has derived views, you will see a mandatory confirmation message during the final publication steps that asks you to acknowledge the potential impact on those views.

When using the Socrata Data Management Experience, you can rearrange, hide and delete columns when reviewing or adding data to your dataset. You will first need to create a revision of your dataset using the action bar.

Once in the new tool, you will first want to select either Add Data or Review Data, based on the action you will take.


This will load the columns in your dataset. Once loaded you can select the kabob in the right-hand corner of the column. This will provide all of the options you can take on your dataset.


Rearrange Columns

While Reviewing Data

The column order you see when reviewing data will be the same order as the published dataset. In order to move the position of a column in the dataset, you can use the Move Left and Move Right options to position the column where you would like it in the dataset.


From Edit Column Metadata

You can now also recorder columns from the Edit Column Metadata option. After selecting that option, you can move the columns around using drag and drop on the position column.

Hide Columns

To hide a column from the dataset view, simply open that same menu and select Hide Column. Hiding a column from the dataset can be undone in further revisions.


Delete Columns

Finally, you can also use the Remove Column option to not include it in your dataset at all. Choosing this option will completely remove the column from the dataset. If you would like to include the dataset in further updates, you will have to add the column back to the dataset.


Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request



Article is closed for comments.