This section provides instructions on adding a segment to the workflow using a SQL node. You can add the generated SQL that you copied from Path to the SQL node.
To use the nPath node instead of SQL node, see Adding the Path Segment.
- Select and drag to the canvas.
- In the properties panel, do the following:
Name Type Find Customers on Bill Dispute->Review Contract Path. Connection Select the Teradata-Vantage database connection that you created earlier. - Double-click the SQL node and paste the code that you copied when you created the path segment.
- Select Save SQL.
- Connect the SQL node to the workflow by selecting and dragging the following:
From To The connector dot in the Start node To the SQL node The green connector dot in the SQL node To the End (success) node - Select Save Workflow.
Your workflow should look similar to this: