Alteryx Designer Desktop Discussions

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

Select records at frequent intervals

JoRao
8 - Asteroid

Hello - I am trying to convert an excel file into a database file and the data looks like in the left image below. I have set up a workflow to select records for under each of the location (Camp Springs, Largo, etc) and then manipulate the data to make it look the way I want it to. The way I am doing it right now is per the image below: Is there a way for me to avoid repeating the select records process and use a tool (sort of like a macro) that can select records at specified intervals? Thanks a lot in advance. 

 

Best,

Jo

 

Sample Data.PNG

 

 Current Workflow.PNG

 

 

11 REPLIES 11
BenMoss
ACE Emeritus
ACE Emeritus
It's the one you sent earlier in the thread 😀
JoRao
8 - Asteroid

Worked like a charm!!! Thank you so very much for your prompt response and help :)

Labels