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

Alteryx designer Discussions

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

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More

Data manipulation

Highlighted
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

 

 

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