Hi All,
I am trying to use the multi row function like I would in Excel. For all columns I need to bring down the the first row of data to other other rows based on column A "Record ID".
I have attached the file. Please let me know how this can be done!
Best,
Jackie
Solved! Go to Solution.
Hi @Jswartz5 ,
Can you provide the results with dummy data to show the output you want to achieve?
Thanks!
@ChiN Here is an example of what I would want the output to be, I only did the first 5 "companies" since it would have too long to the whole file.
Hi @Jswartz5, attached is one approach that helps fullfill the multi-row calculation across multiple columns. Let us know if this isn't that you are looking for.
Is there a reason it wouldn't work with my current WF?
I have attached my WF.
Hi @Jswartz5, it doesnt work due to the empty cells being nulls in my case while they are blank in yours. Modify the logic inside the multi-row formula tool to this and it should work:
IF ISEMPTY([Value]) THEN [Row-1:OUTPUT]
ELSE [Value]
ENDIF
I used ISEMPTY instead of ISNULL function.