Multi-row formula for survey questions

[MagicT]

Hi everyone!

I hope this message finds you well. I'm currently working on a data processing task using Alteryx, and I'm seeking your expertise to help me with a specific challenge. Here's the scenario:

I have a dataset containing survey responses (1-5), from multiple universities over several years. In the dataset, there are null values in the "response-value" column that I'd like to fill using the Multi-Row Formula tool. 

How should I go forward to fill in the NULL-Values?

This is a sample of how my data looks like now. (In my dataset, I have 10 indexes (mean of all survey-responses, in the same category), for 30 universities)

Year	Uni_name	Study_program	Uni_location	Uni_ID	Observation	Value
2020	A	A	London	1	Total_students	100
2020	A	B	London	1	Q1	4
2020	A	C	London	1	Q2	2
2021	B	A	Manchester	2	Total_students	200
2021	B	B	Manchester	2	Q1
2021	B	C	Manchester	2	Q2	2
2022	C	A	London	3	Total_students	150
2022	C	A	Manchester	3	Q1
2022	C	B	London	3	Q2	2

[TimN]

Hi,

Take a look at the Imputation Tool under the Preparation folder.  It can fill Nulls with a few different options.

Regards.

[caltang]

Not sure what you're trying to do @MagicT 

What do you want to replace the nulls / empty records with?

Without using the multi-row tool, you can just filter out the nulls or emptys with

IsNull([Value])
OR
IsEmpty([Value])

From there, whatever you filter out can be fixed accordingly, then reintegrated back into your dataset.