In-DB Workflow Data Stream Out

andersom

I'm working with an In-DB workflow and need to route the output from a Filter In-DB tool (specifically the "U" anchor) into two separate Join In-DB tools. However, I'm unable to connect the U anchor to either a Data Stream Out or any other downstream In-DB tool. The anchor appears active, but won't accept connections.

I've confirmed:

• The U anchor is from a properly configured Filter In-DB tool.

• All downstream tools are In-DB compatible.

• I'm dragging from U into the input anchor of the next tool (not the reverse).

What's the correct method to split or reuse the U output across multiple joins?

Thanks in advance for any guidance.

Data Stream Out.png

alexnajm

You can't connect the standard processing tools with In-DB tools: https://help.alteryx.com/current/en/designer/tools/in-database-overview.html#in-database-tool-anchors-and-connections

You need to bring the data back into the database using the Data Stream In tool if you want to use the Unique tool - otherwise I'd probably look at using the Summarize  In-DB tool instead so you don't have to use the Data Stream Out tool