To fill an empty field using multi row tool

[Tid14]

 

Hi, I am working on a dataset where in I have to apply some formula using Multi row to fetch the result

In the image attached, 

I want to apply formula wherein, if Row 1 and Row 2 of column A are both same, then the empty field of Column B should have same data that is in Row 2 of Column B which is “SAP096543”

Any help on this?

[binuacs]

@Tid14 One way of doing this

[Raj]

@Tid14 Another method attached

[Tid14]

Hi @Raj can you please send me screenshot of the WF attached. i am not able to download it.

thanks in advance :)

[Raj]

@Tid14 please find attached

mark done if solved.

 

 

[jdminton]

You might want to consider a different approach. I'm not certain if this will be it since I don't know your data, but this method will identify all of the associated columnA records and fill in columnB without needing a multi-row tool. Also, you may end up with more than one record that would match requiring several multi-row formula tools to get everything correct. This would eliminate that need. It may need adjustments based on your actual data though.

Summarize tool config: