This is a simple request, but I don't know how to pivot this table in Alteryx as I am able to in Excel. Please see attached screenshot.
Thanks in advance
@denisejohns
Hope I understand your intention correctly. 😁
Hi @Qiu,
Thank you for response. I'm sorry I didn't explain very well that the table you have as the input is actually the output I am trying to accomplish in Alteryx.
Hi ArtApa,
Thank you too for your response and again, I apologize for not giving a clear description of what I am trying to accomplish. Your solution is a useful tool and I will be able to use it for another problem.
The RecordID field is a text field padded with 0s to enable a sort when I concatenate a string to it. In the attached screenshots, I have updated the examples.
I'm sorry for not describing my need completely.
Hi @SDJ57 - I have updated the workflow to change ID from Int to String and Padded zeros. You can then change the data as you want the workflow will work:
Hi ArtApa! It is perfect! Thank you!
@SDJ57 - Would you like to mark one of the posts as a solution? It's the best practice to do so, if you are happy.
Hi ArtApa,
I contacted the moderator Tuesday, because for some reason I am not seeing the option to chose a solution. I contacted the moderator again