Hello Alteryx Community, wondering about a way to convert vertical data like
into
Attached yxmd gives the sample input and output results.Thanks 😀
Hi @chrissgtan
Use the summarize tool, like it was used on this topic: Solved: Re: Workaround for SQL 1000 maximum numbers in a l... - Alteryx Community
You can do this with the Summarize tool.
Hey @chrissgtan
You can do this quickly using a summarize tool!
Solution attached.
Thank you @Felipe_Ribeir0 , and I learned also about overcoming the Oracle 1,000 limit too :-)
Thank you @gabrielvilella ... I incorrectly used the Cross Tab tool ... now I know the new usage of the Summarize tool :-)
Thank you @gautiergodard I incorrectly used the Cross Tab tool ... now I know the new usage of the Summarize tool :-)
