Lookup more than Row+1 or Row-1 or Not calculate from top to bottom

[lolwat12345]

Hello, I see that the multi-row formula only allows Row+1 or Row-1

However, is there a way to lookup a row and append a value to that row, whenever a condition is met

Basically, I need to append Parent's value to Child's value

Group	Type	Reference Tag	Value	Append Value
1	Normal	Null	100
1	Child	1	Null	200 [Lookup from Parent's Value]
1	Normal	Null	300
1	Normal	Null	100
1	Parent	1	200
1	Parent	2	300

I am not sure if I can sort in a manner where all the Parent's row will go first, because I also need to consider the [Group] column in the dataset

Group	Type	Reference Tag	Value	Append Value
2	Normal	Null	100
2	Child	2	Null	300 [Lookup from Parent's Value in the table above]
2	Normal	Null	300
2	Normal	Null	100
2	Parent	3	200
2	Normal	Null	300

Is there a way or a tool I can use so that Alteryx can stop calculating from top to bottom, and append the value whenever Parent's value to its according Child's row?

The linkage of Parent and Child could be found in the Reference Tag, which is unique for each pair.

Thanks!

[alexnajm]

If it's helpful, you can change the rows to look up and down more than 1 by changing the "Num of Rows" option!

Otherwise I am a bit confused what's the original data and what's the expected output - can you clarify?

[Bren_Spill]

@lolwat12345 - see if the attached helps. 

[Qiu]

@lolwat12345 
I am aslo a bit confused as @alexnajm .

At least for Group 2, I can not see "300 [Lookup from Parent's Value in the table above]". The Reference tags are different between the only Parent and Child, so what is the look up logic here?

[Bren_Spill]

@Qiu @alexnajm I assumed it was one table split in 2 - then you can join on the reference tag