Can I delete a field when updating a dataset?

Question

I used a test file which by mistake had 1 additional column. I wanted to go back to my old dataset with correct data instead of just testing. Quicksight doesn't allow me to replace the dataset because of the additional column in the test dataset. Excluding that column doesn't help.

I don't want to create the dashboard from the beginning just because of this. But if I have to, the owner of Quicksight should have predicted such thing happening. Autosave also is forced on so also cannot go back to my old version.

Answer

You can remove the field from the analysis by excluding it from the dataset. This also makes the data table being imported into spice smaller, returning the results faster.

If that doesn't fit your needs you can create a new dataset with the excluded column and replace the existing dataset in your analysis. In the analysis under **Visualize** click the edit icon next to **Dataset**.

![Edit Dataset](/media/postImages/original/IM38Inlr6GRKyLlkNiKzdXvg)

Click on the kabob menu (three dots) and choose **Replace**.

![Replace Dataset](/media/postImages/original/IMQvn4NinbQYm5FNLEXio54Q)

Click the new dataset name and **Select**, you will get a message stating that it will "*clear the undo/redo history for this analysis.*" As long as the fields you used are the same the dashboard visualizations will remain unchanged.

Can I delete a field when updating a dataset?

Relevant content