Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here

Missing Metadata in Filter In-DB tool using Macro

Alteryx
Alteryx
Created

Environment Details


  • Alteryx Designer

 

A Filter In-DB tool is used in the workflow connected to a macro. The macro contains the In-DB connected to a database server. The Output is supposed to contain the metadata together with the queried data. However, the metadata is empty in the Filter In-DB tool even after running the workflow.

 

idea Skyscrapers



Cause


The cause is found to be the missing Output Name in the Macro Output In-DB tool.

idea Skyscrapers



Resolution


Ensure that the Output Name of the Macro Output In-DB contain a value.