Crosstab without aggregation?

[MOrtez1]

I have data:

Customer	Type	Value
1	Date	8/18/2018
1	Amount	100
1	Date	8/19/2018
1	Amount	150
3	Date	8/20/2018
3	Amount	200
3	Date	8/21/2018
3	Amount	250
9	Date	8/22/2018
9	Amount	300
9	Date	8/23/2018
9	Amount	350
9	Date	8/24/2018
9	Amount	400
9	Date	8/25/2018
9	Amount	450

And I want it to come out like:

Customer	Date	Amount
1	18-Aug-18	100
1	19-Aug-18	150
3	20-Aug-18	200
3	21-Aug-18	250
9	22-Aug-18	300
9	23-Aug-18	350
9	24-Aug-18	400
9	25-Aug-18	450

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

[ponraj]

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.

[jasperlch · Accepted solution]

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:

[ponraj]

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

WorkflowResults