Transform vertical data into SQL "In ( )" statement

[chrissgtan]

Hello Alteryx Community, wondering about a way to convert vertical data like 

into

Attached yxmd gives the sample input and output results.

Thanks 😀

[Felipe_Ribeir0 · Accepted solution]

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

[gabrielvilella · Accepted solution]

You can do this with the Summarize tool. 

[gautiergodard · Accepted solution]

Hey @chrissgtan 

You can do this quickly using a summarize tool!

Solution attached.

[chrissgtan]

Thank you @Felipe_Ribeir0 , and I learned also about overcoming the Oracle 1,000 limit too :-)

[chrissgtan]

Thank you @gabrielvilella ... I incorrectly used the Cross Tab tool ... now I know the new usage of the Summarize tool :-)

[chrissgtan]

Thank you @gautiergodard I incorrectly used the Cross Tab tool ... now I know the new usage of the Summarize tool :-)