Searchcaster

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

13

0

49

In reply to @dwr

No INDEX MATCH? Psh

1

0

5

In reply to @dwr

Xlookup is what the cool kids do

2

0

8

In reply to @dwr

I want my angel check back.

2

0

11

In reply to @dwr

Export a table then use SQL expression in Google Sheets 🧠

0

2

In reply to @dwr

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.

0

1

In reply to @dwr

Jupyter notebook is the way to go

0

2

In reply to @dwr

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

0

2

In reply to @dwr

Still (slightly) better than using MS Access…

0

In reply to @dwr

Product Managers everywhere just felt a disturbance

0

1

In reply to @dwr

excel runs the world

0

1

In reply to @dwr

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

0

3

In reply to @dwr

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

0

In reply to @dwr

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

0