topic How to export to Excel data that uses In-DB Tool in Alteryx Designer Desktop Discussions

How to export to Excel data that uses In-DB Tool

Herijale21 — Mon, 08 Apr 2024 23:40:28 GMT

I brought over information that came originally from Data Bricks, and I did it using the "Connect In-DB Tool"; however, I can only use the "In DB" tools now to manipulate this information, while I can see the filter and summarize options, I can't seem to connect it to any of the normal tools of Alteryx such as the Output Data that allows me to export the results to Excel. Is there a way to convert this information into normal inputs or export in some other way?

Thanks!

Re: How to export to Excel data that uses In-DB Tool

alexnajm — Mon, 08 Apr 2024 23:42:13 GMT

Data Stream Out is the way to go!

Re: How to export to Excel data that uses In-DB Tool

alexnajm — Mon, 08 Apr 2024 23:43:17 GMT

You can use it to connect to the standard Alteryx tools, and/or be able to export to Excel: https://help.alteryx.com/current/en/designer/tools/in-database/data-stream-out-tool.html

Re: How to export to Excel data that uses In-DB Tool

Herijale21 — Mon, 08 Apr 2024 23:45:39 GMT

Thanks!