Use ARRAY_AGG to flatten columns to lists.


You need to convert a long table of values into a list? This is the most convenient function.

πŸ“Œ Syntax:
πš‚π™΄π™»π™΄π™²πšƒ π™°πšπšπ™°πšˆ_𝙰𝙢𝙢(πšŒπš˜πš•πšžπš–πš—) π™΅πšπ™Ύπ™Ό πšπšŠπš‹πš•πšŽ

There you go, the column is flattened into a list separated by comma.

❌ To do so, I used to copy the entire column into a spreadsheet tool, transpose it, and use some Excel magic to convert it to a list. And I'll never do it again.

You can use it with GROUP BY and get separate lists! Full example below.

More from Travis Tang
Pivot Table (From Long to Wide)

Pivot Table (From Long to Wide)

Every data scientist, scientist, and engineer should know how to create a pivot table. π™²π™°πš‚π™΄ πš†π™·π™΄π™½ is the best way to do
Find duplicates with RANK

Find duplicates with RANK

Let's clean out duplicates! Here's how. 1️⃣ Check if duplicates exists. Use π™Άπšπ™Ύπš„π™Ώ π™±πšˆ + π™²π™Ύπš„π™½πšƒ(*) to find duplicates. See example 1 in image
Great! You’ve successfully signed up.
Welcome back! You've successfully signed in.
You've successfully subscribed to Travis Tang.
Your link has expired.
Success! Check your email for magic link to sign-in.
Success! Your billing info has been updated.
Your billing was not updated.