Strategy ONE

Refine Data Quality Before Importing

Use data wrangling to improve the quality and usability of your data before importing it. You can remove white space, filter, delete duplicate rows or cells, find and replace data, concatenate columns, etc. In addition, you can use data wrangling as a data discovery tool and to bypass some traditional extraction, transformation, and loading (ETL) methods.

If you republish or refresh your data, the data wrangling steps apply to the new data.

Filter Data Using Functions

  1. Open the Preview dialog.
  2. Click the table drop-down.
  3. Click Wrangle.
  4. Select a column.

  5. Select a function.

    See Functions for Wrangling Data for more information. To define data and time data types, see Define Date and Time Data Types When Wrangling Data

  6. If necessary, define the parameters and click Apply.
  7. As you make changes, they are added to the script. Use the buttons next to Script to modify your script.