Free Trial

Alteryx Designer Desktop Discussions

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

Multiple "Group By's" using the Summarize Question

jdelaguila
8 - Asteroid

Below is an example of what my Data looks like, along with an attached Workflow I'm working on. 

 

In a nutshell i want to create a workflow that runs a group by count on every field, except the 1st field [SEQ].

 

The catch here is that all the field names, except for [SEQ], change all the time. 

 

Is there a tool i can use that can run a "Group by" count on all fields, except my SEQ field, regardless of what the field name is called?

 

In the example below, all the fields in BOLD change every day, so i need the tool to just run a Group By count on every field regardless of field name, except for the SEQ field of course.

 

Any help would be greatly appreciated. Thanks!

 

This field name never changes 
SEQPARTYSCOREGENDERAGENET WORTHDONOR FLAGIDEOLOGY
77016UnaffiliatedFrequent VoterF35J062
561164UnaffiliatedFrequent VoterF35J062
12586UnaffiliatedFrequent VoterF35J062
3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@jdelaguila 
how about a transpose tool.
This would be dynamic and would not depend on your field names.

0127-jdelaguila.PNG

jdelaguila
8 - Asteroid

This worked perfectly! Thank you.

 

Javier

Qiu
21 - Polaris
21 - Polaris

@jdelaguila 
Glad to help 😁

Labels
Top Solution Authors