Add a #0* in front of specific rows

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

Datasets

Parse

Transformation

Accepted answers

atcodedog05

Hi @dpakapd

Its possible using Multi-row formula tool.

Workflow:

Hope this helps : )

add identifier.yxmd

All comments

atcodedog05

Hi @dpakapd

Its possible using Multi-row formula tool.

Workflow:

Hope this helps : )

add identifier.yxmd

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.

New Workflow2.yxmd

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!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703