Hi Everyone,
A quick question. How do you change the format of data in alteryx. For example my input is this:
I want each appointment and event attended (respectively) to count for "1" irrespective of the total. So even if a student has attended 5 events I want it to equate to "1" because we're interested understanding the number of students who attended an event/appointment - not how many they attended in total.
Therefore, I want my output to be this:
Please can you help? I think I have to use the formula tool.
Solved! Go to Solution.
Thank you!! I was using the formula tool and not getting anywhere!
Happy to help : ) @suds144
Cheers and have a nice day!
I have another question.
What if my input was this
And I wanted to combine the appointment attended and appointment drop-ins into one so my final output looks like this
Thank you!!! Yesssss! This worked!