I am new to Alteryx and am having trouble with data preparation. I am sure this is going to be an easy solution but for some reason I am struggling to format my data accordingly.
Here is what my data looks like:
App ID | 10000 | 10001 | 10002 | 10003 |
260608 | 3934 | NULL | NULL | NULL |
260608 | NULL | 10000 | NULL | NULL |
260608 | NULL | NULL | 2251.79 | NULL |
260608 | NULL | NULL | NULL | 3618.95 |
260609 | 2225 | NULL | NULL | NULL |
260609 | NULL | 989 | NULL | NULL |
260609 | NULL | NULL | 3261.54 | NULL |
260609 | NULL | NULL | NULL | 4829.18 |
This is what I am looking for:
App ID | 10000 | 10001 | 10002 | 10003 |
260608 | 3934 | 10000 | 2251.79 | 3618.95 |
260609 | 2225 | 989 | 361.54 | 4829.18 |
I am using the cross tab tool but cannot seem to get all values on the same line for a given application.
Thanks in advance.
IJH34
Solved! Go to Solution.
Hello,
You will need to use the Summarize tool to complete this. Group by the 'App ID' then you will need to do a sum on all the remaining fields. See screenshot below.
Hope this helps.
Nick
Thanks @NickC. Much appreciated!
Hey @IJH34 - did you manage to get to a solution that worked?
If so, would you mind marking this thread as solved - or if not, lets work together to get you to a solution.
Many thanks - have a good weekend
sean
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |