Macro Input Field Names

BRRLL99

Hi

I have build standard Macro with sample data , column names are completely different names with original data but process is same.

I have selected Show Field  Map

when I inserted in my original data, I'm receiving string and int , 2 drop downs

In the original data set I need to do Group by description and count by description

Since description is string type, that option is not coming in the second drop down

Sample macro has been attached please look into it. 

sample.yxmc

patrick_digan

@BRRLL99 Hopefully the attached is what you're looking for. You have 2 columns in your macro (DATA and SALES). The user needs to map these 2 columns, but it sounds like you want SALES to be optional (when they check the count box, SALES isn't needed). I don't believe you can map 1 field to both Data and Sales; instead, here's how I would handle it:

0) The macro didn't have the show field map checked, so I checked that.

1) I changed the field name in your macro input from "SALES" to "SALES (Optional)". Alteryx has special coding that now doesn't require the Sales field to be passed given the title includes (Optional).

2) I updated Select (22) to revert the SALES (Optional) back to SALES. 

3) I updated Summarize (9) and Summarize (10) to count on DATA.

Now your macro can accept just 1 field and use the count method:

Sample 2023-02-21.yxmd

sample2.yxmc