Using the examples

Each scenario includes training data, block order, exact settings, expected results and verification steps. Replace demo_* identifiers with your own objects. JSON snippets explain configuration; they are not ready-to-import archives.

Files and data preparation

01
Convert CSV to JSON

Read a semicolon-delimited sales file, preserve column names and produce JSON for the next integration.

02
Excel: months from columns to rows

Prepare a wide Excel budget template for loading into a model with a period dimension.

03
JSON: extract an array of nested records

Take the data.items array from JSON and create a flat CSV with a consistent column order.

04
XML: product catalog to Excel

Select repeating XML elements, use the id attribute as the code and write the catalog to Excel.

05
Normalize codes and remove duplicates

Normalize product codes to one spelling and retain the last record for each code.

06
Sequential quality rules

Correct missing values and negative quantities, replace Excel errors and reject rows containing unacceptable text.

Calculations, combinations and routes

07
Revenue and regional totals

Calculate revenue for each sale and prepare a summary table by region.

08
Join: sales with a price reference

Join prices to sales by a numeric key while retaining rows with no price.

09
Union: combine branch data

Combine two sales datasets into one table by column names, even when their order differs.

10
Route large orders

Split orders into priority and regular orders by amount, with a separate file for each branch.

11
Route using a limits reference

Compare a request amount with its department's individual limit rather than a single constant for everyone.

12
Filter with a run parameter

Let the user choose a region and minimum amount without editing the flow itself.

Databases and external APIs

13
SQL: select open orders

Read a limited set of SQL records with one SELECT query and create a verification CSV.

14
SQL: upsert product reference data

Update an existing product by its sku key and add a missing product to a training SQL table.

15
REST API: orders from a JSON response

Read an API resource, extract the data.items array, retain open orders and produce Excel.

IBM Planning Analytics

16
IBM Planning Analytics: export a public view

Read a public IBM Planning Analytics cube view and pass it to a tabular report.

17
IBM Planning Analytics: Excel budget to cube

Unpivot months in a budget workbook and write four values to a training cube with explicit mapping of every dimension.

18
IBM Planning Analytics: run TurboIntegrator

Start one training TI process with a fixed year and a scenario chosen in the execution wizard.

Interactivity and notifications

19
Manual scenario selection and branch merging

Let the operator approve or reject a set of requests and return to a shared export after the selected action.

20
Exception notifications by email and Telegram

Find orders with a negative amount and send a concise report to a control group through two channels.