a man is making a funny face with his mouth open ALT: a man is making a funny face with his mouth open

That feeling you get when you reduce an Excel file size from 106MB to 65KB by simply using #PowerQuery

...Coz i #PowerQueryAllTheThings 🔥

#PowerQuery #SQL #PowerQueryAllTheThings #PowerQueryTodasLasCosas

Topic: SQL Dynamic Pivot & Unpivot
Features: Replicating PQ pivot and unpivot other columns, fully dynamic
SQL requires some heavy hardcoding.. but not anymore!

Medium Blog: https://buff.ly/4e70qO2
Github: https://buff.ly/4e0Kj4D

Yeah sex is cool but have you ever used Text.BetweenDelimiters()?

Spoiler Alert: SQL is a hot mess in this department. Forgettaboutit

#PowerQueryAllTheThings

#PowerQuery #CustomFunction #PowerQueryAllTheThings #PowerQueryTodasLasCosas

Advanced use of Table.InsertRows() - dynamically inserts columns
Features:
• Insert ID/KEY value
• Filler for remaining columns
• Row Position (Top/Bottom, any row)

Github: https://buff.ly/3LZwpEb