Advanced
Dan Romero@dwr
10/29/2022

SQLfessions: I usually just export multiple tables and use VLOOKUP and Pivot Tables in Excel. 🫠

In reply to @dwr
phil@phil
10/29/2022

No INDEX MATCH? Psh

In reply to @dwr
Varun Srinivasan@v
10/29/2022

Xlookup is what the cool kids do

In reply to @dwr
Antonio García Martínez@antonio
10/29/2022

I want my angel check back.

In reply to @dwr
Rob@rob
10/29/2022

Export a table then use SQL expression in Google Sheets 🧠

In reply to @dwr
GabrielAyuso.eth ⌐◨-◨@gabrielayuso
10/29/2022

I hate doing this in spreadsheets. I rather dump to CSV and import into a regular SQL query engine. I mostly use the internal equivalent of BiqQuery.

In reply to @dwr
10/29/2022

Jupyter notebook is the way to go

In reply to @dwr
10/29/2022

The SQL purist in me will push me to quit FC at this rate … I generally do the other way around..

In reply to @dwr
Karthik Senthil@karthiksenthil
10/29/2022

Still (slightly) better than using MS Access…

In reply to @dwr
Anupam Batra@actuallyepic
10/29/2022

Product Managers everywhere just felt a disturbance

In reply to @dwr
10/29/2022

excel runs the world

In reply to @dwr
Connor McCormick@nor
10/29/2022

use coda (disclaimer, coda pays me a shit ton of money to cast that)

In reply to @dwr
Mai@mai
10/30/2022

Totally feel you, I also started using Metabase and it saves so much time!

In reply to @dwr
Graham Siener@gsiener
10/30/2022

Hook up google sheets to your database for the real power 😜