◄Show Table of Contents

Dynamic Input In-DB Tool

The Dynamic Input In-DB tool takes In-DB Connection Name and Query fields from a standard data stream and inputs them into an In-DB data stream.

This is an In-Database Tool.

In-Database enables blending and analysis against large sets of data without moving the data out of a database and can provide significant performance improvements over traditional analysis methods. For more about the In-Database tool category, see In-Database Overview.

Why you would use this tool

The Dynamic Input In-DB tool is used in conjunction with the Dynamic Output In-DB tool when creating an In-DB macro for predictive analysis. The Dynamic Input In-DB tool can take In-DB Connection Name and Query fields from a standard data stream and input them back into an In-DB data stream.

How to use this tool

1. Drag a Dynamic Input In-DB tool from the Tool Palette onto the workflow canvas.
2. With the Dynamic Input In-DB tool selected, configure the tool using the Properties window on the left.
3. Connection Name Field: The alias for the In-DB connection to the database .
4. Query Field: The In-DB query created at this point in the workflow.

Click Apply to have the configurations accepted.

Alteryx.com | Community | Customer Support | Documentation Feedback

©2018 Alteryx, Inc., all rights reserved. Allocate®, Alteryx®, Guzzler®, and Solocast® are registered trademarks of Alteryx, Inc.