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

Alteryx designer Discussions

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

Crosstab without aggregation?

Atom

I have data:

CustomerTypeValue
1Date8/18/2018
1Amount100
1Date8/19/2018
1Amount150
3Date8/20/2018
3Amount200
3Date8/21/2018
3Amount250
9Date8/22/2018
9Amount300
9Date8/23/2018
9Amount350
9Date8/24/2018
9Amount400
9Date8/25/2018
9Amount450

And I want it to come out like:

CustomerDateAmount
118-Aug-18100
119-Aug-18150
320-Aug-18200
321-Aug-18250
922-Aug-18300
923-Aug-18350
924-Aug-18400
925-Aug-18450

For the life of me I can't get this working properly in Alteryx... any help!

Quasar
You can use cross tab tool to get the desired result. ie) select customer in key field section and keep type and value in name and key field respectively. Just try and let community know in case of any further help.
Quasar

Hi @MOrtez1,

 

I think you would need to add a RecordID using a Mulitple Row Formula and Group by the RecordID and Customer Field inside your Cross Tab tool:

 

Capture1.PNG

Quasar

Here is the sample workflow for your case.  Hope this is helpful. 

 

workflow.PNGWorkflowResults.PNGResults

Labels