Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Crosstab help needed - need to sum and count

jdelaguila
8 - Asteroid

Hello everyone!

 

I'm new to building Cross Tabs and i'm trying to build the below using the data attached - see attached file Crosstab_Problem.yxmd.

 

The problem i'm having is building the COUNT field which sums up the FCODE and LISTSEG field, and than the STATE field needs its each individual count. 

So basically FCODE, LISTSEG and COUNT would be my Rows and ISTATE would be my Column.

 

Any help would be greatly appreciated. Thanks!

Javier

 

This is what i'm trying to get with the Workflow attached. No

FCODELISTSEGCOUNTARAZCACOCTFLGAIAILKSMAMDMIMNMONCNJNVNYOHORPATXUTVAWA
HFHOUS101118 1101362531021231915342125
OL009049               49          
OL02191                     1    
OL09369    9                     
OL209020               20          
OL309018               18          
OLNB042  11                      
3 REPLIES 3
jeff_reynolds
10 - Fireball

Oops, never mind. missed something in your post. 

jeff_reynolds
10 - Fireball

I think the attached workflow does what you're looking for. 

deviseetharaman
11 - Bolide

Updated @jeff_reynolds's Workflow. Removed the Select Tool and Replaced it with Dynamic Rename Tool.

Labels