Alteryx create new row base on some condition

[187]

Hi guys,

i have some data like this, I want to sum b and c group by a's value, normally column a has value L and E , i need to create row E and put 0 if there is no E in column a, i know how to do if a has L and E, but if one is missing, i dont know how to create one row , any advice? thanks!

a	D	b	c
L	XX	1	2
L	XX	3	4

the result look like this:

a	D	b	c
L	XX	1	2
L	XX	3	4
	L	4	6
	E	0	0

[Sebastiaandb · Accepted solution]

Hi @187 ,

Here you go!

I hope this is what you're looking for :-).

Greetings,

Seb

[187]

Thanks seb that is exactly what i want  thank you so much

[Sebastiaandb]

@187 No problem, glad to help! Have a nice day!