Transform streaming data

Transform data type & format easily

You can transform a type and format of live data on Outcode layer with a click. For example,
Text to Number type
Text to Date(time) type 
Number to Currency format 
Number to Text type 
There are many other ways to transform data. Transformation will be applied to only to each column. Transformed data is displayed on the layer in real time. 
Transformation of data on a layer working as proxy. This doesn't impact the raw data connected from your data source. 
How to transform data 
It is easy to transform data. Set a transformation on each column. Click a data type icon on a column.  
Select a Data type on the left as a destination. For example, all email address in a TEXT column is transformed to LINK, if LINK is selected.
What you see is what you automate. The transformed data will be loaded to quick action. 
​
Text
Select TEXT to transform data type as text. 
Number
Select NUMBER to transform data type as number. It doesn't work if data is not changeable. (*then choose the data type before you try)
PERCENT
Display data in Bar chart format. Set min and max values. 
A negative value(-) is not allowed.
DATETIME
A useful transformation. Any data formats in Google Sheets or Excel are TEXT.   
From TEXT to DATETIME 
Change Timezone and format of DATETIME.  
Set simple two steps to use DATETIME transformation;
1.FROM(raw data before transformed)
2.TO (transformed data as destination)
Set From 
First select timezone and format of raw data as displayed on OUTCODE layer. Usually choose the same time zone in FROM and TO. 
Second, Select a correct format of data as displayed on a layer. For example, DATETIME in MySQL might look like the below;  
2022-07-29T09:05:30.000Z
yyyy-MM-dd'T'hh:mm:ss.SSS'Z'
(Year-Month-day-hour-minute-second-millisecond)
T(simple separator)
Z(time zone UTC-0) 
a (am-pm of the day) 
//It is just a sample. The format depends on your data sources and configurations.
You can choose the correct format. If you can't find the right one, select Customize and type in the format of raw data.   
​
yyyy-MM-dd'T'hh:mm:ss.SSS'Z'
Year-Month-day-hour-minute-second-millisecond
TO 
Set DATETIME and Format as a destination. 
​
CURRENCY 
Transform number to currency type 
​
LINK 
Transform text to URL type 
​

Automation - Previous

Referencing data

Next - Automation

Filter streaming data

Last modified 7mo ago