Can we achieve without using Multirow formula
Solved! Go to Solution.
@SHRAO_SURYA Why can't you use a multi-row formula?
If ISNULL([Year]) THEN [row-1:year] ELSE [Year] ENDIF
Is by far the simplest way to clean this data. There may be other approaches, but they will be much much much more complicated
Ollie
Now I am working on Alteryx cloud there is no Multirow Formula but i need same output can you please help on this
surprise that alteryx cloud do not have multi-row formula tool.
here the long way I tried. mainly use summary + text to column + replace.
first have to use formula tool to convert null to "+" (or other symbol) for add in summarize tool.
then to avoid the complexity in the formula tool add "|" to ensure first 4 digit is year.
merge to 1 rows without separator.
use text to column to split by "|" to year in rows.
use formula to replace the "+" to year, and add separator.
replace([Concat_year],"+",","+left([Concat_year],4))
use text to column to split to rows.
lastly use join by recordID
workflow:
btw, I not sure it works when AMD engine is on. please check it first.
I would like to express my sincerest gratitude to you for generously investing your time and expertise in resolving the issue
Thank you, for your unwavering dedication and commitment to excellence.
Its working as expected
Hi Peachyco
I would like to express my sincerest gratitude to you for generously investing your time and expertise in resolving the issue
Thank you, for your unwavering dedication and commitment to excellence.
It's working as expected