Duplicate Alteryx rows based on condition?

Crispy131

I have data that looks like the following table (with a few other columns). The problem is when I write an IF statement saying IF "Money" THEN [Value] ELSEIF "GP" THEN [Value] I don't get the correct value for GP as some of that value ended up falling under 'Money'. Same goes for if I used 'Costs' instead of Money.

Earning Profit    Sales    Value

ET	GP	Money	23
ET	GP	Costs	56
ET	GP	Costs	87
ET	GP	Money	42
ET	GP	Money	15
ET	Asset	Property	62
ET	Asset	Property	35

I want to use Alteryx to duplicate the Money rows and the Cost rows exactly as is but to make the Profit field blank as I'm hoping that will stop the IF condition issue. I have never done something like this before so not sure how to do it?

Really appreciate the help!

K_Vinogradov

Hi @Crispy131!

I believe the issue can be solved without duplicating the data. Could you send the exact formula you're using, or elaborate on the formula you would like to achieve?

In case you do believe data duplication is the only way to proceed, you can create a separate stream of data, use formula tool to set profit to blank, and combine it using the union tool. Just like this:


Hope this helps!