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

Alteryx Designer Desktop Discussions

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

Macro gives error "Unknown Field Type"

LFerg
6 - Meteoroid

I've made a macro to cleanse and capitalize certain name types and it works fine with the _test_field_

However, when I try to use it in a normal workflow I get the error "Unknown Field Type" regardless of whether its a file (xlsx or csv) I'm using as input or like the below text input (I have attached this test program)

 

 

LFerg_0-1664805944592.png

 

Tool 8 is the first of my multifield formulas (titlecase and cleanse punctuation) and I cannot see anywhere that it's configured wrong, but it must be.

I have attached the macro to this post and hopefully someone can help me get this working. 

 

LFerg_1-1664806205375.png

 

 

2 REPLIES 2
DataNath
17 - Castor
17 - Castor

@LFerg in your macro, you're currently using an action tool to change the field incoming field type that the List Box looks for:

 

DataNath_0-1664807417641.png

 

When using the List Box in select mode, you ought to be able to just plug this straight into the Q anchor of the tool in question:

 

DataNath_1-1664807452366.png

 

Upon doing so, the flow should run as expected:

 

DataNath_2-1664807483717.png

LFerg
6 - Meteoroid

Thank you so much!

Labels
Top Solution Authors