Macro Text Box Question

jbh1128d1

Hello,

How can I allow for a free type text box with more than one column and correctly show that in the interface designer?

I would like to be able to type in some variables and their corresponding values to be used in a formula at the end of a macro.  Is there any way to do that? See picture below:

NicoleJohnson

Ah, okay, I see... Then you might look at using the Multi-Line option in the text tool, and then just providing additional instruction on how to enter your selections. See attached... basically, indicate how you want your variables separated (i.e. identify the delimiter to use), and then instruct the user to enter a single variable-value combination per line. You can then feed your results into a text field and use two Text to Columns tools to parse out the variables & values (split to rows by newline to separate different entries... and then split to columns using your specified delimiter). You could then use Cross-Tab to pivot the data to show your variables as headers and the values selected below each header.

Does that help? I'm not aware of a tool currently that will allow you to set up multiple individual text boxes (though there are a few Alteryx wizards out there who might have other ideas)... but this method at least would allow for any number of variables.

NJ

AppPrompts2.yxwz