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 | |||||||
SEQ | PARTY | SCORE | GENDER | AGE | NET WORTH | DONOR FLAG | IDEOLOGY |
77016 | Unaffiliated | Frequent Voter | F | 35 | J | 0 | 62 |
561164 | Unaffiliated | Frequent Voter | F | 35 | J | 0 | 62 |
12586 | Unaffiliated | Frequent Voter | F | 35 | J | 0 | 62 |
Solved! Go to Solution.
@jdelaguila
how about a transpose tool.
This would be dynamic and would not depend on your field names.
This worked perfectly! Thank you.
Javier
@jdelaguila
Glad to help 😁