Transforming data

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.

Datasets

Input

Data Investigation

Accepted answers

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

Hope this helps : )

Here is how you can do it.

Workflow:

Hope this helps : )

Student in attendance (Appts).yxmd

All comments

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

Hope this helps : )

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

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!

Quick Links

Unanswered
Community Events
Groups

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703