community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.

Give option for the user to select field tag(required,Optional) in analytic app

Meteor

Hi community,

 

I have a below requirement to create an analytic app.

 

1) File browse: to browse for the input file

2) Tag fileds: once file is browsed, user should get the option to tag the fields

                 Ex: Field1, Field2, Field3

                 Here Field1,Field3 are Optional to select by user and Field2 is the required field to be selected

Actual logic in the workflow

Create a formula based on the above field tagging:

If user selects Field1,Field3 then I have concatenate Field1 and Field2(to get unique ID) elseif Field2,Fiel3 then concatenate Field2 and Field3---this unique id is used in Join condition.

 

and one more user interface to perform the summarization using the unique id above based on the user selection to tag the other fields like Field5,Field6,Field7 i.e. if user selects Field1,Field2 for the unique id, I need to join two files using this unique ID and for the joined records, group by that unique id and get Summarized values of(sum,max..) field5 and/or field6 and/or  field7(this slection of fields has to be passed from the user tagging in the app)

Appreciate the help.

 

 

Thanks,

Ram

Bolide

Hey @RAMN,

 

There are probably a few different ways to do this. If I understand the question correctly then you would want to leverage the Error messages to ensure they have some sort of value in the Required fields, but the optional fields would not have an error message associated to it. I think if you are wanting the user to specify the Required fields you may need to use a text box to have them state (maybe separated by some delimiter) what fields are going to be required and which ones will be optional. I don't have an example I can share for this exact purpose but put together a sample in the attached workflow.

Labels