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 |
Solved! Go to Solution.
Here you go!
Please like and accept this solution if it answers your question!
Hope this helps!