"Crosstab-ing" a date

[missteran]

Hi Alteryx team - could someone please help: I have an example where I am trying to put each unique trade ID essentially into a single row to be able to compare month over month how their maturity dates changed and/or how their amounts changed. Is there a way to create the output (2nd table below)?

Input (original data layout)

Month End Dates	Trade ID	Maturity Date	Amount
9/30/2022	123456-ABC	2/1/2036	350,000
8/31/2022	123456-ABC	2/1/2023	353,000
9/30/2022	89101112-DEFG	8/1/2028	150,000
8/31/2022	89101112-DEFG	8/1/2024	100,000
9/30/2022	131415-HIJ	10/28/2029	500,000
8/31/2022	161718-KLM	3/1/2024	200,000

Output:

Current Month End Date	Trade ID	Maturity Date as of 8/31/2022	Maturity Date as of 9/30/2022	Amount as of 8/31/2022	Amount as of 9/30/2022
9/30/2022	123456-ABC	2/1/2023	2/1/2036	353,000	350,000
9/30/2022	89101112-DEFG	8/1/2024	8/1/2028	100,000	150,000
9/30/2022	131415-HIJ		10/28/2029		500,000
9/30/2022	161718-KLM	3/1/2024			200,000

[gautiergodard · Accepted solution]

@missteran 

Here you go!

Please like and accept this solution if it answers your question!

Hope this helps!

[binuacs · Accepted solution]

@missteran One way of doing this

[Emmanuel_G · Accepted solution]

@missteran 

Find in attachement a way of doing that.