The Wrangle Your Data page allows you to explore your data to evaluate its quality and usability. You can then prepare your data to improve its quality before you import it into the application. For example, you can remove white space, filter your data, delete duplicate rows or cells, find and replace data, concatenate columns, and so on.
You work with sample data (a subset of your actual data) to build a script that will clean and prepare your data, also known as data wrangling. The completed script is applied to your data when you publish the cube.
The Wrangle Your Data page is displayed after you import data from Excel or CSV files imported from your computer or local network.
The Wrangle Your Data page contains the following areas:
Set Sample Size: By default, 1,000 rows of data are displayed in the Data Preview window. By setting the sample size, you can add up to an additional 10,000 rows for a more representative sample of your data.
Enter a number in the data field or use the slider to change the number of rows. Your selection is added to the initial 1,000 rows. For example if you enter 2,000 in the data field, then 3,000 random rows will be displayed in the Data Preview.
Click Finish to perform the random sampling. The results are displayed in the Data Preview.
Functions: Allows you to select a function to apply to the selected data.
For a function that needs no further input, like facet, the function is automatically applied to your data.
If the function needs parameters, define the parameters, then click Apply to apply the function to your data.
Suggestions: Displays a list of suggested functions to apply to the selected data column. The suggestions are based on the sample data that you select.
History Script: Lists your functions. Allows you to redo and undo applying functions. The history script is saved with the dataset and therefore in the dashboard. You can also export the script, to save the functions in order. You can then import the saved script to apply to another set of data. Steps for both are included in Refining your data quality before importing.
Data Preview: Displays a sample of the whole dataset. Data Preview: Displays a sample of the whole dataset.
Select a data column or part of a cell to apply a function to.
After you apply a function, the sample data is updated to preview the effect of the function.
Facet: Displayed when a facet (filter) function is selected. Allows you to filter your data in a variety of ways, so that you can focus on a smaller amount of data as you refine the data. Rows are not deleted when you use a facet function.
When you have completed refining and cleaning your data, click OK to apply the script to your actual data.
For detailed steps to refine your data, and a full list of functions, see Refining your data quality before importing.
Refining your data quality before importing
_____________________________
Copyright © 2019, Oracle and/or its affiliates. All rights reserved.
Legal Notices