community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Data manipulation

Meteoroid

Does anyone have a solution to the following:

 

From:

 

01/07/2014  01/08/2017  
SalesCOGSProfitSalesCOGSProfit

10

551055
11651165

 

To:

 

AmountCategoryDate
10Sales01/07/2014
5COGS01/07/2014
5Profit01/07/2014
10Sales01/08/2014

 

 

Highlighted
Asteroid

Hi @TomH1,

 

Here's one way you can do it, the only downside with this workflow is that if your dataset is much larger than the example you gave above then it will take some manual adjustments to make it work. I'd started a fully automated version for this but it would take a while, hopefully this should make some sense when you see the workflow.

 

Any questions please just ask,

 

Thanks,

 

Michael

Pulsar

Give the attached a try.  I had to split the data into three streams (1st row, 2nd row, and remaining) and do a little bit different manipulation for each.  I'm also assuming that rows 3+ should be summed up in the "Amount" column, so if that's not the case you'll need to play with it a little.

 

Hope it helps!

Alteryx Partner

hi @TomH1,

 

Take a look at a workflow that I have attached. Hope it would help you in solving your problem.

Labels