In this article I am going to explain as what is data wrangling and how to apply data wrangling functions in OAC.

Data wrangling is a new option in OAC to easily modify and aggregate data post-upload. Several options are available depending on each column type.

Below is a screenshot from OAC where you can apply data wrangling functions -

Below is a screenshot showing different data wrangling functions available for Date columns- 

Below is a screenshot showing different data wrangling functions available for Measure columns - 

Below is a screenshot showing different data wrangling functions available for Attribute columns- 

Applying Data Wrangling Functions for Date Column

Below is one example of how you can apply data wrangling function to a Date column -

Click Options button of Date column and select Year to extract year to a new column

To rename the column, click Options and select Rename. Enter new name and click OK.

Similarly you can extract Quarter, Month, and Day from Date Column.

Applying Data Wrangling Functions for Measures

Below is one example of how you can apply data wrangling function to a Measure column -

Click Options button of the column and select Conditional Group.

Applying Data Wrangling Functions for Attributes

Below is one example of how you can apply data wrangling function to an Attribute column -

Click the Options button of the column and select Split.

This concludes this article .

I hope by the end of this article you should have learned how to apply data wrangling functions in OAC .

Anirban Basu

Add comment