Issues with multi row formula

[FilipViterra]

Hi guys,

Looking for a bit of help with the multi-row formula.

I have attached the current vs desired state, but can't seem to make it work, I haven't had the chance to work much with alteryx.

Can someone help?

Thanks a lot,

Filip

[IraWatt · Accepted solution]

Hey @FilipViterra,

I have attached an example of how to do this:

If you want to learn more about the Multi-Row-Formula Tool the community has some quick and easy videos on the topic here: https://community.alteryx.com/t5/Interactive-Lessons/Multi-Row-Formula/ta-p/82872

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[JamesCharnley · Accepted solution]

Hi @FilipViterra, Here's how I would match your desired output. One multi-row is to update the New Status column until the year is not active, and the next will add one to the first active until the same point

[binuacs · Accepted solution]

@FilipViterra One way of doing this

[FilipViterra]

Hey,

Thanks for the help! Really nice!

I was wondering how do I reset when the customer number changes - to start again from one, the number of interactions.

I'll have a look at those tutorials, thanks!

Filip

[binuacs · Accepted solution]

@FilipViterra You need the select the CLIENT_NR field in the Group By column of the Myulti-Row formulas

[FilipViterra]

Worked great, thank you so much!