Hi, team. I am new to alteryx. Could you help me in resolving the following issue.

[vnktalteryx]

V_c	year	c_c	mass
M1	2020	eu28	100
M1	2021	eu28
M1	2021	uk
M1	2022	uk
N1	2020	eu28	90
N1	2021	uk

for the mass of M1, 2021,eu28 and next two rows needs to be assigned the values of 100. like wise N1, 2021, uk too need to have value 90.

how this is to be done? please help me out!

[BS_THE_ANALYST · Accepted solution]

@vnktalteryx I think the Multi-Row is what you're looking for here:

workflow is attached

[vnktalteryx]

this is good.

There is a performance issue with multi formula tool. 

Could you help in another way of resolving this issue please?

[BS_THE_ANALYST]

@vnktalteryx because the empty cells are referencing ones above them, it only strikes me to use the Multi-Row tool. This is using multiple tools though, so in all honesty, it might be worse in terms of performance. Worth a shot though!

I used @binuacs idea of a lookup table. Please credit him if it works.