Alteryx create new row base on some condition

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

Help

Accepted answers

Hi @187 ,

Here you go!

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

Greetings,

Seb

All comments

Hi @187 ,

Here you go!

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

Greetings,

Seb

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

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

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703