Hello and good evening my Alteryx friends. Happy post voting day! I the following and I need some support
INPUT
unit | store | expenseCd | cost |
123 | ab660 | rental | 100 |
123 | ab660 | other | 99 |
456 | cx790 | rental | 1200 |
456 | cx790 | other | 68 |
456 | cx790 | add | 1000 |
I need the following Output. One row for the unit, displaying as many expense codes listed (usually no more than 6), and summarize the cost.
unit | store | expenseCd1 | expenseCd2 | expenseCd3 | CostSummary |
123 | ab660 | rental | other | 199 | |
456 | cx790 | rental | other | add | 2268 |
Your help is most appreciated.
Solved! Go to Solution.
Hi Yalmar,
i wasn't exactly clear on the setup for your solution. I did try based on the image, but I am still getting multiple lines instead of 1.
Thank you David. This worked. I will try and apply it to the 1 million records and see if I have any hiccups.