Upgrading Server to version 22.1? We’ve enabled the faster AMP engine by default. Read about how these system settings changes might affect you.

2022-05-24 Updates: Login: If you are facing issues with logging in, please try clearing all your cookies or trying another browser. We have a fix being deployed on the evening of 5/25. Email: If you're not seeing emails be delivered from the Community, please check your spam and mark the Community emails as not junk. Thank you for your patience.

Alteryx Designer Discussions

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

Created a Macro but in need those input in the Alteryx App interface.

Rihan_Mohamed
7 - Meteor

Hi

 

I created a Alteryx Macro and you can see the dropdown list in the macro (screenshot below)

Rihan_Mohamed_0-1593173221022.pngRihan_Mohamed_1-1593173238733.png

But my requirement is to convert this to Alteryx App, Can someone help me.

 

I tried to change the settings from Macro to Analytic App but showing no configuration.

Rihan_Mohamed_2-1593173358488.png

 

I think we need to point a Action tool and point some drop down tool for the macro, But still showing some error.

 

Attached the workflow and macro for the same.

 

4 REPLIES 4
jarrod
12 - Quasar
12 - Quasar

with macros that use data from a stream, you'll need to feed the macro the same way when in the app. There are two ways to do this with the app:

1) add a question that uses a file input question or

2) pass through a single record using a text input tool and multiple text input or dropdown questions to update the values.

 

For this macro, it looks like you are wanting to input multiple records, so you'll want to go with route #1. 

 

jarrod_0-1593176304492.png

jarrod_1-1593176316020.png

 

#2 looks a little different: 

 

jarrod_2-1593176688249.pngjarrod_3-1593176698808.png

 

also, i'm not sure why there is an action in the macro, so it looks like you can remove it. 

 

 

Rihan_Mohamed
7 - Meteor

The input i get will be having different column headers, SO thats why i created a workflow and need to map accordingly. 

 

Input file (the column header names may vary based on client)

 

Rihan_Mohamed_1-1593324712212.png

Workflow and Mapping done in the workflow

 

Rihan_Mohamed_0-1593324688725.png

Ouput

Rihan_Mohamed_2-1593324970138.png

 

Requirement

I need the drop down list to come on the Alteryx App.and map the fields in App interface.

Shingo
Alteryx
Alteryx

You need to use an file browse tool from the interface tool pallet with the "Generate Field Map for Input Tool" option.  Connect to an input tool with a  template data set which has a ideal field name information with an Action tool. You can select a file with mapping fields with the fields in the template. Attaching a sample workflow and a template.

 

Shingo_0-1593403438698.png

 


Shingo Sakai

Sales Engineer
Alteryx, Inc.


jarrod
12 - Quasar
12 - Quasar

hey @Rihan_Mohamed , sorry for the confusion. @Shingo 's explanation would change my workflow into the field map you are looking for. I don't think i had the box checked, but if you make that one change, it should get you what you need. To that point, if your purpose of the macro was to rename/align the fields, you shouldn't need that anymore since that work is being done in the app through the mapping option. 

Labels