Introduction
In this workout, we received weather data from weather machine, where every hour degree are stored in a column, and degree for each area are represented as a row. To easily work on this data, we need to transpose the data from column to row.
sample source data
Requirements
- Create a dev org or use an existing org you have access to.
- Upload the CSV file into CRM Analytics.
- Create a Recipe to transform the data, so each value is represented as a row.
Dataset
You can retrieve the sample data here, in this example: the weather is in Celcius degrees and the data is only retrieved at 12 am, 8 am, and 4 pm.
Tipps
Make use of “Format Numbers” to show the weather in 00.0 format, and “Rename Column” to change the table headers.
sample result
Share
After you finish your workout, share a screenshot of your solutions or interesting insights.
Either on Twitter using the hashtags #WOW2024 and #CRMA and tag @genetis, @LaGMills and @msayantani @simplysfdc. (Or you can use this handy link to do that)
Or on LinkedIn, tagging Alex Waleczek, Lauren Mills, Sayantani Mitra and Phillip Schrijnemaekers, Johan Yu using the hashtags #WOW2024
Also make sure to fill out the Submission Tracker to track your progress and help us judge the difficulty of our challenges.