Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Macro Output Metadata for Dynamic Table Source

Highlighted

Hello,

 

First timer here.  I've got a Macro that I've inherited that allows you to pass a DB connection and a table name, and it appends the data from the table.  It's slightly more complicated than that (in that it actually is something one would use), but that's the gist.

 

The problem I'm facing is that when I pass in a table that's not the default parameter, I don't get metadata out about the fields that should have been added to my data.  I'd like to be able to put a Select tool after the macro and have the database fields available there as well.

 

Thoughts?

 

Thanks!

 

Highlighted
Alteryx
Alteryx

@zackklemm can you post the workflow and macro here without the data for us to take a further look?

Highlighted

Attached.  Thanks!

Alteryx
Alteryx

@zackklemm 

 

It looks like all the Input Parameters are driving from the yxdb file.  If that is the case, will the table name / Dataset name have to be in that file also?

 

You should be able to use the Dynamic Select tool to bring back the metadata / fields / columns.

Labels