This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a data that looks like this : i want to create a field called Number_of_occur in alteryx
so that the output will look like this.
this is how you will do it in sql :count(ID) over (partition by ID ) number_of_occur
Can somone help me. Thank you
You are able to accomplish this with the Summarize tool, and a join tool in Alteryx.
With the Summarize tool, you will want to set up the following:
Group By ID
Group By Name
Join this back into your source data and remove the duplicate fields.
Ive attached a sample workflow to show you how I did this.