Description The Cleanse node cleanses text columns in a data set. Configuration Options Basic Configuration Options Setting Description\Parameters Text Columns to Cleanse Columns from the parent node that should have text cleansing applied to them. Trim Leading/Trailing

Configuring Nodes Nodes can be configured by double clicking on them on the canvas. Node Specific Settings Depending on the type of node, the available node settings will be different. Each of these are further at Node Guide . General

The Cloud Connector can be used to call a flow from a TI Process to a Euclid Studio instance, if that Euclid Studio instance is made publicly available via the Cloud Connector. To configure cloud connector, click on Cloud

Row Node Group A Row node can transform individual records in a result set; It combines, reorders, or otherwise acts on the rows. A Row Node should always be a middle node in a segment.

Adding Nodes to the Canvas Nodes can be dragged from the left-hand pane to add them to the canvas. Nodes in this pane are grouped according to their function; i.e., all Source nodes (nodes that import data

Description The Database source node imports data from a database table. Configuration Options Basic Configuration Options Setting Description\Parameters Database Connection The database to query against. These connections can be configured through the guide at Flow Connections . SQL Dialect

Description The Flat File Export Node node is used to export a data set to flat file. Configuration Options Basic Configuration Options Setting Description\Parameters File Name Location of the file to export. This is the full path to

Description The Filter Node renames, reclassifies, or filters out a column or group of columns when connected to a source node or a preceding node that is not an output or export node. This node outputs ALL the columns

Common Node Features Feature Description Properties Some general node settings can be updated on the Properties tab. See Configuring Nodes for more information. Preview , Run Many nodes can have their output previewed or run after configuring the node. Unique

Navigate to a specific node http://localhost:9696/EuclidStudio/api/v1/flows?flowFileName=c:/Flows/example.flx&runProfile=default&nodeId=node_9259502 Responses Status Meaning Description Schema default Default successful operation None

Nodes are individual objects that process data in a specific way. I.e., a node might import data from a flat file, a second node might add a new column to that data set, and a third node might

Description The Command Line Output node is used to run arbitrary REST commands. Configuration Options Basic Configuration Options Setting Description\Parameters Request Type HTTP request type Request URL URL to make the REST call against Body Body data for

Uninstalling Euclid Studio Ensure tomcat is still running. Navigate to the tomcat webapps folder and delete the Euclid Studio.war file. Wait until the Euclid Studio folder is rermoved by tomcat (this will only occur while tomcat is running

Description A Script node outputs data through a script. Configuration Options Basic Configuration Options Setting Description\Parameters Script Type The scripting language ( R or Python ). Script The script to run. Any code should be placed in the section denoted

Documentation Flow Examples Run a flow Run a flow by setting the File Name of the Flow node to ##EXERCISE_SOURCE_DIRECTORY##/Examples/Output/Flow/FlatFileExport.flx . Running this node will now run the FlatFileExport.flx flow.

Description The Frequency node is used to calculate the frequency of a value conditon occuring across rows. For example, you can calculate the number of rows that have a column containing a value greater than 1. Configuration Options Basic

Description The Partition node is used to split a data set randomly, using a predefined seed number. A new 'ROLE' column will be created with the default values 'TRAINING' or 'SCORING' for each row. Configuration Options Basic Configuration Options

Description The Business Rule node uses business rule logic to drive column value changes. Configuration Options Basic Configuration Options Setting Description\Parameters Number of Rows to Use for Fixed Values Number of rows of input data used to populate

Description The Command Line Output node runs arbitrary command line commands. Configuration Options Basic Configuration Options Setting Description\Parameters Full Path to Executable The full path to the executable run as part of the command. Parameters Parameters run with

In this section, we provide a collection of business problems that can be solved using DataWORQ. These business problems can also serve as an introduction to DataWORQ features and node types, allowing the user to become more familiar with