Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Issue with Macro Input In-DB

dtiana
6 - Meteoroid

Good morning,

I'm trtying to build up a In-DB Macro working with Impala; let's say just as example:

 

- Macro Input In-DB

- Formula In-DB: to create a new variable

- Macro Output In-DB

 

macro_Input_In-DB.jpg

As shown, the Macro Input In-DB use a file definition for the connection (ODBC) and a generic select as query.

Then I use the macro in a simple workflow:

 

- Connect In-DB: same file definition for the connection and same select as query as in the macro

- My Macro: defined above

- Data Stream Out

- Browse

 

workflow.jpg

Running the workflow returns the error '..missing field map...'.

I get the same error even if in the Macro Input In-DB I leave the query empty.

 

Other details:

 

-Connect In-DB

Connect_In-DB.jpg

 

-Formula In-DB

formula_In-DB.jpg

 -Connection configuration file

connection_file.jpg

- ODBC configuration

ODBC_Impala_1.jpg

 

ODBC_Impala_2.jpg

SSL-Options.JPG

ODBC_version.jpg

 Thanks in advance for any help.

Have a nice day,

 

Davide

2 REPLIES 2
Ramirezphl
5 - Atom

Has this been fixed? I have the same issue on my end.

jNunez
8 - Asteroid

How do you have the macro configured in the workflow containing it. I see inside the Macro for the Macro Input tool, you have "Show Field Map" selected, but you did not include any screenshots show how you have it configured in the larger workflow. That would help us help you.

Labels