Dataflows
Your first steps with Dataflows
Data sources communicate with source systems of all kinds and deliver the data mostly in form of a table. To display this data, you can either access it with the controls or use a script to process it first. Read here how Postprocessing table data works or how to manipulate table data. In this article you will learn how to post-process various data with little scripting knowledge using dataflows. With dataflows you can for example
- Name columns cleanly and delete columns that are not required.
- Adjust data types.
- Add new columns and fill them with content according to a certain logic.
- Link several data sources with each other - also from different source systems - and merge them into a single new table.
Dataflows allow you to start from a single table and gradually adjust the data set until the result meets your needs. You can review, change, and add to the individual steps for each dataflow in the Peakboard Designer. This makes it easy to check whether the sequence has the desired effect, and the expected result appears.
Create a new dataflow
Click on […] next to [Dataflows] or your [Datasource] in the explorer to create a new Dataflow.
Next, select your base table (1) and confirm via [OK] (2). Even if several tables are involved in the data transformation at the end, the dataflow always starts with exactly one table. Use the text field (3) to assign a unique name for easier identification of the dataflow.
Now all preparations are done. Via [Add Step] (4) further transformation steps can now be applied to the table. In the right area of the dialog all already applied steps are listed. Of course, they can be changed or deleted later. Click on one of the steps and display the state of the data AFTER this step in the dialog area on the left. The dataset in this example is, as you can see in the screenshot below, of course still in its initial state.
Finally, you can set whether the dataflow should be updated together with its source or should follow its own interval (5).