New Rows on Conditions of Existing Rows - Revenue

[EMPMUK]

Hi All, 

I have some data within my set that sits within a specific department and is a revenue source for that department but this activity can also be a revenue source for another department (however the billings need to be reported against the main department). What I would like to do is identify which rows in my database are going to be dual revenue sources and copy them with most of the date but not the billings. Is there an easy way to do this?

In the example below, I would have this data for the tailoring department and would like to generate the data for the jewels department. 

Dept	Order No	Product	Month	Area	Gross Billing	Revenue	Diamond Buttons?
Tailoring	11	Blazer	Jan	London	100	10	y
Tailoring	12	Tie	Jan	Glasgow	50	5	n
Tailoring	13	Shirt	Jan	London	20	2	y
Tailoring	14	Blazer	Feb	Manchester	200	20	y
Tailoring	15	Square	Mar	Glasgow	10	1	n
Dept	Order No	Product	Month	Area	Gross Billing	Revenue	Diamond Buttons?
Jewels	11	Blazer	Jan	London		0.1	y
Jewels	13	Shirt	Jan	London		0.02	y
Jewels	14	Blazer	Feb	Manchester	0.2	y

Thanks in advance, 

EM

[TimN · Accepted solution]

Hi,

Something like this perhaps?

[cjaneczko]

Does this work?

[EMPMUK]

Thanks Both!

TimN, I'm very new to Alteryx and haven't had much time for the training yet but so didn't realise I could do something as simple as process one input in 2 different ways and join it again - have for sure been overcomplicating things!

Thanks, 

EM