Add a #0* in front of specific rows

[dpakapd]

Hello,

I have a large text file with data about sales.

The most basic format of the data is as shown below. There are multiple rows with similar data and there are other rows with noise that I don't want to consider.

In order to make my data filtering easy I would like to add a #0* in front of a row whenever the previous row has the word 'VISION' in it.

So for the example above, the output would be 

VISION Y2 TOTALS
#0* 11,398.38 0.00 11,398.38 0.00 11,398.38 8,151.34 28%

Is this possible with Alteryx? 

Thanks

[atcodedog05 · Accepted solution]

Hi @dpakapd 

Its possible using Multi-row formula tool.

Workflow:

Hope this helps : )

[Adarsh_R3]

Hi, @dpakapd, as @atcodedog05 have explained we can do that in Alteryx. 

Just make sure that when you add new text to the existing row, the data size of the particular field should be sufficient to accommodate the new values. Otherwise, the ending of the text will be truncated. 

[dpakapd]

@Adarsh_R3 and @atcodedog05 :

Thank you so much!

This really helped. I had a feeling I had to use the Multi-row but wasn't quite sure how. Thanks again for this incredible insight.

[atcodedog05]

Happy to help : ) @dpakapd 

Cheers and have a nice day!