Analytic app incorporating some data preparation steps

Thats odd!

Are you sure you're on 11.5?

I've attached a version downgraded to 11

All comments

Rename App.PNG @LordNeilLord

Hey @sg1207

See if this set up works for you

Part time Tableau, Part Time Alteryx. Full Time Awesome

Data Lover

BenMoss

So you will need two interface tools, the drop down tool and the text box tool.

You can then simply overwrite placeholders that you would have in the 'select' tool (to select only one field and rename it accordingly), and also the summerize tool, where you group by the variables, and finally the filter tool to remove missing values.

Example attached.

Ben

SimpleMacro.yxmc

thanks Ben!

this macro works fine. But what if the variable name changes in my input file. say, my input has variable "vendor_full_name", in that case the macro will throw an error.
any clue on how to fix that!

hi @LordNeilLord

Thanks for the quick response.
However not able to open up the workflow as I'm using an older version 11.5.
The version upgradation seems diffIcult in my office environment.

Any quick remedy for that?

Here we go!

still not working @LordNeilLord!
just asking, have you used any functionality which is available only in the latest version?

No, standard tools..what error do you get?

"This workflow was created by a more recent version of Alteryx, and may contain tools not present in the version. Alteryx does not support usng an earlier version of Alteryx to open a workflow created with a newer version. For best result, download the latest version of Alteryx.
Do you still want to attempt?"

if i click OK now, it's not opening..
Got the same message while opening the sample macro which Ben shared, but it did open after hitting OK.!

Thats odd!

Are you sure you're on 11.5?

I've attached a version downgraded to 11