Forums

Full Version: Performing Data Transformation using Excel or CSV data connector
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
How can we do data transformation when using Excel or CSV as data connector?
(06-17-2019, 09:35 AM)noopur.mehrotra Wrote: [ -> ]How can we do data transformation when using Excel or CSV as data connector?

You can use scripts, calculated fields in dashboard to do transformation. If you are using excel to create the data store and use it in business story (adhoc-report), you have formula fields to manipulate the data.
We even have an option to do number of data transformations using the data preparation module . The module has a list of 50+ transforms that can be performed  on csv data.This transformed data can be exported and consumed by the visualization modules