Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.
SOLVED

Multi Row Formula to Make te Below Rows Nulls

DataPirate26
9 - Comet

I want to write a multi row formula to make the below rows as nulls if it has the same name as in the previous rows. I have attached a dummy data file to make it more easier to understand where i have provided the input data and how the desired output should look. Can anyone help me write this multi row formula ? 

3 REPLIES 3
AngelosPachis
16 - Nebula

Hey @DataPirate26 ,

 

I used a multi-row formula tool to count the number each header appears. Then with a formula tool, I nulled the value in the header column if the count is greater than 1.

 

AngelosPachis_0-1625457819403.png

 

Hope that helps.

 

Regards,

 

Angelos

 

DataPirate26
9 - Comet

That Helped. Thank you so much for the response. 

Vaithi
7 - Meteor

Hi Soumyadipsarkar26, This can be done in 2 ways. One using multi row formula and another using tile tool. Attaching the workflow for your reference. 

Labels