Relational Operations

WFBs that manipulate relations data.

Name	Description	Parameters	Result
Relational Datasource	Connect a relational data source	Datamodel and Datasource: Where the data is located Existing Table: Bind existing table Table: The relational data table …: define the filtering criteria as well as sorting and columns Delta Filter: A delta filter is used when you want to filter data based on a date, and this filtering is done when you want to know the data which is new after the last time the workflow block was called Ad Hoc Table: Link table depending on the selected data source Table: name of the table you want to select Preview: Preview the table data Ad Hoc Table – Type: type of the container Ad Hoc Table – Name: Name for the newly created table Ad Hoc Table – Resource: name of the resource Ad Hoc Table – Method Type: None, Get, Put, Post, Delete, Options Parameter: Parameters which will be sent to the container Options: Password, Worksheet name, start row and column, Range name, Whether the container has headers or not Structure: The columns of the container and their data type, and whether to show them or not	Returns a WorkflowDataReaderInfo object on the current parameter
Export Data	Export relational data into a relational table	Data Model: where the table is stored Data Source: where the table is stored Existing Table: If the table is already created Ad Hoc Table: if the table does not have a specific structure Table: the name of the table to be exported into. Ad Hoc Table – Type: type of the container Ad Hoc Table – Name: Name for the newly created table. Ad Hoc Table – Resource: name of the resource. Ad Hoc Table – Method Type: None, Get, Put, Post, Delete, Options Parameter: Parameters which will be sent to the container Options: Password, Worksheet name, start row and column, Range name, Whether the container has headers or not Structure: The columns of the container and their data type, and whether to show them or not. Export settings: Write the data automatically to the table. Block-Mode: allows writing into the table using block insert instead of singular insert. Enable trigger: Trigger an event for each operation, if turned on the performance will be effected heavily if the data set is big. Columns to export: Select which columns will have what data inserted into them. Connection: Allows you to write SQL command to export data, not recommended	N/A
Generate DataReader	Identical to relational data source, except the data is supplied from another source. The current parameter must contain a list of data entries of the selected table. After using the data reader, you should have a loop to use it correctly	Datamodel and Datasource: Where the data is located Table: Table that specifies the data structure Select all: Select all columns shown	A WorkflowDataReaderInfo object is returned as current parameter
Unite Datasources	Connect data sources (Ex, Relational Datasource and Generate DataReader). If a loop is connected after it, it will loop over the left data source, and then the right data source	N/A	N/A
Simple Data Comparison	Carry out data synchronization between 2 different relational data sources. For example, if you connected to a container from an outside source and you want to check if the current table you have stored locally is outdated, you can use this workflow block to synchronize between them. The left side is the source and the right side is the target data source. The source should be looped over before connecting into the block. The blue input is used for the end of the loop.	Primary Key: Find the rows to be compared from source and target (Ex. UniqueIDs) Primary Key – Source: Columns from the source table Primary Key – Target: Columns from the target table Hashed Column in Target: Column with hash value for comparison in target if any Hashed Column Source: Columns from the source table being hashed Hashed Column Target: Columns from the target table being hashed Removed deleted columns in target: Returns a WorkflowDataReader object with all rows that are not in source. Target source is read completely at once Block size: if remove deleted columns in target is deactivated, then this size is read in and processed	Green outputs return a WorkflowDataReader with the current row. Per record, output New Line Of Data is a new record. Per data record, output Changed Data Line, one data entry has changed. Per record, output Unchanged Data Line, there was no change. Exit End, comparison is finished. Deleted data rows: a WorkflowDataReaderInfo is returned
Reset Delta Info	Rest the delta filter for the current workflow. A delta filter is used when you want to filter data based on a date, and this filtering is done when you want to know the data which is new after the last time the workflow block was ran. The WFB must ran once for the Delta filtering to be available for a data table	FEID: The Delta filter that you want to reset	N/A
Execute On Data Row	Used when you want to execute something on the data row ignoring the reader	N/A	The current row (WorkflowRowReader) is assigned to the current parameter
Read Out Column Values	Read out the column and set it to status key and/or current parameter	Column: Select column Status Key: Set column value in status key	Returns current parameter if set. If this is set, it is not possible to continue working with the WorkflowDataReader (green inputs/outputs) afterwards, but only with the value read out here
Edit Columns	Change or add columns	Add column: Checkmark to a Add new column Column Name: Specify column name if Add column is activated Column: Select column when add column is disabled Formula: Define column value Datatype: Define column datatype	N/A
Change Column Type	Change the data type of a column	Column: Column name of the column to be changed Datatype: Define the data type of the column	N/A
Add Columns	Add columns from another table	Search Column: Add Search Colum row based on which comparison is performed. If multiple are found, only the first is returned Search Column - LookUp Column: Base Column Search Column -Comparison Column: Comparison column from second data source Select All: Columns from the comparison data source to be added	N/A
Convert To Object	Convert from a WorkflowDataReader into an object that can stored inside a data structure. Both input options should be connected to generate the data	Existing Property: Select existing table Existing Property – Datamodel: Table Data model where tis stored Existing Property – Datasource: data source where it is stored Existing Property – Table: Object table, this is used to generate the properties Generate Object – List: Property must be of type list Generate Object – Object: Property must be of type object	N/A
Aggregate	Aggregate over a data table. The input should be a for loop with objects to aggregate over	Groupings – Column: Column by which to group Aggregations – Column: Column for aggregation Aggregations – Aggregation: Aggregation applied to the selected Column	Returns the aggregation results in a list, with each element containing a list of values, the column aggregated in the first and the aggregated value in the second
Pivot	Transform the rows of a table into columns of a table	Pivot-Column: The column that will be used as the name of the created columns Aggregations-Column: The column that will be used as an aggregation value. Aggregation: The aggregation type Grouping – Column: Column or grouping	N/A
Unpivot	Transform the columns of a table into rows of another table	Use For Unpivot – Select All: Select column to be unpivoted Show in Result – Select All: Columns to be shown in the result Unpivot Value Column Heading: Heading of the unpivoted value Show Column Headings of The Unpivot Columns: Show column headings Unpivot Column Column Heading: Heading of the unpivoted column	N/A