Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

New Rows on Conditions of Existing Rows - Revenue

EMPMUK
6 - Meteoroid

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. 

 

DeptOrder NoProductMonthAreaGross BillingRevenueDiamond Buttons?
Tailoring11BlazerJanLondon10010y 
Tailoring12TieJanGlasgow505n 
Tailoring13ShirtJanLondon202y 
Tailoring14BlazerFebManchester20020y 
Tailoring15SquareMarGlasgow101n 
         
         
DeptOrder NoProductMonthAreaGross BillingRevenueDiamond Buttons?
Jewels11BlazerJanLondon 0.1y 
Jewels13ShirtJanLondon 0.02y 
Jewels14BlazerFebManchester0.2y 

 

Thanks in advance, 

EM

3 REPLIES 3
TimN
13 - Pulsar

Hi,

Something like this perhaps?

cjaneczko
12 - Quasar

Does this work?

 

image.pngimage.png

EMPMUK
6 - Meteoroid

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

Labels