Often times the data from source systems require preparation and data transformation prior to being loaded to another system. To support this requirement, OneCloud offers CSV Transformation to perform various tasks such as:
- Column & Row filtering
- Split & Join columns
- Find & Replace
- Add unique row IDs
- Smart filtering based upon timestamps, numeric values, and text strings
- Advanced Tabular Query for mapping and lookups
This data transformation quick start guide will walk you through setting up OneCloud to perform various valuable functions to demonstrate how data can be prepped by OneCloud while be transferred from a data source to a target. This quick start guide will have the following exercises:
- Basic data transformation and branching logic to split data.
- Smart filters for parsing log files and other human-readable datasets.
- Advance tabular query to map and blend datasets together based upon standard query language.
Not all sections need to be completed, but some do build off of work from completed prior sections.
How do I get access to OneCloud?
We have made it easy for people interested in OneCloud to get access. Simply visit https://app.onecloud.io/new-user to spin up your own full-use trial of OneCloud.
If your company is already a OneCloud customer and you would prefer to use your primary OneCloud environment for this tutorial, then please contact your OneCloud system administrator to ensure you are added to a security group with Workspace administrator access. Please contact email@example.com if you require additional guidance.
Set up up connection parameters to access sample data for the exercises.
Learn the basics of OneCloud transformations including column transformations and find & replace
Learn how OneCloud Smart Filters work and how to use them.
Create transformations that include using simple standard query language (SQL) to blend and lookup data.