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.

[alexnajm · Accepted solution]

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-anchor...

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

[abacon]

@andersom I would use the in-db summarize as well, if you can avoid it, going out then back in to in-db tools feels like a waste of the benefits. Try @alexnajm's solution with the summarize tool and that should fix your problem.

Bacon