ONE DATA Tips and Tricks

Efficient Workflow Building
5 golden rules If you consider 5 golden rules, building and especially maintaining a workflow is way more efficient and faster: Specification → Specific...
Thu, 30 Jul, 2020 at 9:56 AM
Reports Usage
Please visit the page about Reports for information how reports can be created and how they work. This helps to understand the example on this page. Report...
Thu, 10 Sep, 2020 at 12:38 PM
Regular Expressions
Extract month and year from a date column (use stringfy before) Regex with the string: [0-9]{4}-[0-9]{2} Extract the month from a timestamp formatte...
Thu, 10 Sep, 2020 at 12:34 PM
Useful SQL Statements
SQL statement for classification evaluation SELECT *, case when ISERROR =1 and ISERROR_FORECAST = 1 then '1' when ISERROR = 0 and ISERROR_FORECA...
Wed, 12 Aug, 2020 at 12:08 PM
Using R in ONE DATA
Background information - communication of ONE DATA and R-Server For using R in ONE DATA it is usually necessary to have a separate R-Server installed. The ...
Thu, 10 Sep, 2020 at 12:34 PM
One Data Python Framework (ODPF)
Content Overview Usage of Global Variables Within a Python Script OD Variables Examples Input Output Dataset Image Model Dataset Structure ...
Tue, 24 Nov, 2020 at 10:24 AM
Hands-On: Python Processors
General Description of the Python Processors The Python Processors give users the ability to add Python codes to a ONE DATA Workflow. These are the types o...
Wed, 21 Oct, 2020 at 3:35 PM
Getting Authorization Token for the OD API
Content Via Browser Developer Tools Get the token from the browsers "localstorage" Get the token from the "Network" tab Via .../...
Thu, 3 Dec, 2020 at 5:15 PM
Working with Date(times)
Content Intro DateTime-Variable in ONE DATA Data Type Conversion-Processor Modifiers DateTime Variables in Spark SQL Syntax Conversions and Manipula...
Thu, 10 Sep, 2020 at 12:35 PM
Reading CSV Files with the Python Script Data Generator Processor
Besides the Filesystem Connection (see the Connections article) in ONE DATA, it is also possible to read in CSV files from the file system with the Python ...
Thu, 10 Sep, 2020 at 12:35 PM