Using Generate Row & Multi Row Formulas

[Kratoulli]

Hi there, 

I'm having some issues duplicating a row of data whereby a certain condition is met and then changing it. I've attached some dummy data below.

In essence I need to take a copy of a row where the customer is married and change the Lifeflag from 'L1' to 'L2', Gender from Gender1 to Gender2, Age1 to Age2 and add an additional column which will then act as the new customer ID, called LifeID. My thought process was that I would need a combination of the generate row, multi-row formula and formula tool to achieve this. Given that I'm still a novice I wasn't quite sure where to start and was hoping for some assistance. 

Thank you in advance! 🙂  

[FláviaB]

Thank you for your post, @Kratoulli! I am moving it to our Designer Discussions board for more visibility! 😉

[mceleavey · Accepted solution]

Hi @Kratoulli ,

Nice and simple, you just need to split the stream into those with part 1 and those with part2. Change accordingly and smoosh back together:

Workflow attached.

Hope this helps,

M.

[Kratoulli]

Hi @mceleavey, 

It worked like a charm, thanks for your help 🙂 

[mceleavey]