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
01Read a semicolon-delimited sales file, preserve column names and produce JSON for the next integration.
Prepare a wide Excel budget template for loading into a model with a period dimension.
Take the data.items array from JSON and create a flat CSV with a consistent column order.
Select repeating XML elements, use the id attribute as the code and write the catalog to Excel.
Normalize product codes to one spelling and retain the last record for each code.
Correct missing values and negative quantities, replace Excel errors and reject rows containing unacceptable text.
Calculations, combinations and routes
07Calculate revenue for each sale and prepare a summary table by region.
Join prices to sales by a numeric key while retaining rows with no price.
Combine two sales datasets into one table by column names, even when their order differs.
Split orders into priority and regular orders by amount, with a separate file for each branch.
Compare a request amount with its department's individual limit rather than a single constant for everyone.
Let the user choose a region and minimum amount without editing the flow itself.
Databases and external APIs
13Read a limited set of SQL records with one SELECT query and create a verification CSV.
Update an existing product by its sku key and add a missing product to a training SQL table.
Read an API resource, extract the data.items array, retain open orders and produce Excel.
IBM Planning Analytics
16Read a public IBM Planning Analytics cube view and pass it to a tabular report.
Unpivot months in a budget workbook and write four values to a training cube with explicit mapping of every dimension.
Start one training TI process with a fixed year and a scenario chosen in the execution wizard.
Interactivity and notifications
19Let the operator approve or reject a set of requests and return to a shared export after the selected action.
Find orders with a negative amount and send a concise report to a control group through two channels.