Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Chaining Application in a loop and storing selections in the order they were selected?

Al12397ey
5 - Atom

The application I am trying to build is that a user can choose a certain option from the interface X number of times and I need to store their selection (and records associated with that selection) and the order in which they were selected.

 

The idea I had in mind was that whenever a user chooses an option an indicator for "the number of times he went in the loop" would be part of the output 

 

For example:

 

In the first loop selection he chooses "DOG" and this outputted as "Output_1"

       the 1 would be the first loop

In the second loop he chooses "CAT" and this is outputted as "Output_2"

       the 2 would be the 2nd time around the loop

I need to build an application that does this loop X number of times and stores the output based on the order in which selection was made.

 

Please let me know if this is possible and any help would be appreciated 

2 REPLIES 2
joshuaburkhow
ACE Emeritus
ACE Emeritus

Hi! @Al12397ey 

 

I haven't done this (yet) but the way I would first try to approach this is to see if I could build two chained apps and then point them to each other (hence, creating a 'app' loop) and then I would need to find someway to 'end' one of the apps (likely by throwing an error) and then all results as one goes through the app would write out to a single file with appends. Does this make sense? A very cool concept for sure! I'll try and take a stab at this ...

 

Joshua

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
Al12397ey
5 - Atom

Hi @joshuaburkhow

 

I actually figured this out, I used a looping concept for the chained Apps and in the app where the User selects an option (dog,cats,hamster etc) I also outputted the DateTime in the file name and a column using the the Datetimenow() function. In the last step I picked up all the files and sorted them by ascending which effectively tells me the order in which they were selected.

Labels