Adding Repeating Table Columns

FlowForma processes automatically generate a table in Azure, containing all process data, for use in FlowForma Analytics. If the process contains a “Repeating Table” question type, a second table is generated in the Azure database containing all the repeating table data. To use this data, you need a data connection in FlowForma Analytics connecting:

Process flow data (parent)
Repeating table data (child)

To create this data connection, set up the FlowForma process data connection as previously documented, then repeat this process for the repeating table. Below we have the “Onboarding” flow connected to the Process Performance Data Connection.

Onboarding flow connected to Process Performance Data Connection

To add the repeating table data that is a question within the Onboarding process:

Select the Add Table button

Select your database and the table you want to extract data from. You are looking for a table named “Tables_‘ProcessName’”.

Select all the data available within the table and select Generate.

A new table will now appear within your data connection.

Select the newly generated table.

Select “joins” and the ”+” symbol seen on the right-hand side.

Select the flow you wish to connect the newly created table to. We are looking to connect to “[Flow_Onboarding_demoflowforma]”.

Select the common data between the two tables to create a connection. Our common data is “formID”: click the arrow button shown in the screenshot below.

A new SQL expression will appear in the box on the right side of the screen.

Test that the connection works by clicking the lightbulb icon, and if you’re happy with the result, select the save icon.

You should now have a data connection model with the onboarding process and the onboarding repeating table joined and ready to create dashboards.

Data connection model with joined tables