Start 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