To fill an empty field using multi row tool

Question

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?

jdminton · Answer

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:

Empty Field.yxmd

Raj · Answer

@Tid14 please find attached

mark done if solved.

Tid14 · Answer

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

thanks in advance :)