Transforming data

[suds144]

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.

[atcodedog05 · Accepted solution]

Hi @suds144 

You can apply the formula using multi-field formula like below.

Hope this helps : )

[suds144]

Thank you!! I was using the formula tool and not getting anywhere!

[atcodedog05]

Happy to help : ) @suds144 

Cheers and have a nice day!

[suds144]

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

[atcodedog05]

Hi @suds144 

can you provide this data in excel.

[suds144]

Thank you :)

[atcodedog05 · Accepted solution]

Hi @suds144 

Here is how you can do it.

Workflow:

Hope this helps : )

[suds144]

Thank you!!! Yesssss! This worked!