Without using Multi row formula

[SHRAO_SURYA]

Can we achieve without using Multirow formula

[OllieClarke]

@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 

[SHRAO_SURYA]

Now I am working on Alteryx cloud there is no Multirow Formula but i need same output can you please help on this

[Pang_Hee_Choy · Accepted solution]

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.

[Peachyco · Accepted solution]

This is pretty convoluted, purposefully working around the Multi-Row Formula Tool. Challenging. 😊

Here's my take, using Row IDs. Appends, and grouping by 12 (using ceiling and division).

 

[SHRAO_SURYA · Accepted solution]

Hi  Pang_Hee_Choy

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

[SHRAO_SURYA · Accepted solution]

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