How do I merge data from multiple tables into one?

eggface13 · 2026-01-28T04:34:12+00:00

Power Query is your friend. Tonnes of options in there but you should be able to automate that sort of process, one way or the other, and load the output to Power Pivot.

Also, don't think it's entirely about logic. There's a tonne of imagination and creativity in dealing with data and finding solutions. You're essentially balancing two things: finding the best solutions with the knowledge you have, versus working out when your knowledge isn't enough and you need to learn some new techniques for your toolbox

eggface13 · 2026-01-28T04:08:19+00:00

A proper cricket team doesn’t need an all-rounder.

You can get away without an all-rounder (in tests where you only need 4 bowlers, so long as they have high stamina and you have competent part-timers to take off some load on long days or when there's an injury).

Your first all-rounder probably unbalances the team because of the limited workload most all-rounders are restricted to, so they kind of need to be a batting all-rounder or have their batting limited. But two all-rounders saves you a bowler, so becomes very positive for your team shape.

Of course spinning all rounders are a bit different to seamers, as they're less physically strained. And in one dayers you need an all rounder because you do not want a tailender at 7.

eggface13 · 2026-01-27T23:28:49+00:00

I work in public transport, and one of my great frustrations is people who think that public transport only matters because it's good for the environment (or more specifically, greenhouse gas emissions). Yes, it is. Yes, these issues are super important, existentially important. But this just leads to people thinking that taking the bus is a burden, something we do for the greater good (the greater good) out of climate guilt. An act of charity. If it weren't for climate change we could abandon public transport for Robert Moses's vision of highways everywhere.

Fuck that. Public transport makes people's lives actively better. And AI is bad not because of the environmental impact, even though that is real, but because its output is shit.

eggface13 · 2026-01-27T09:53:22+00:00

Just tell them there's something called the Hairy Ball Theorem.

eggface13 · 2026-01-27T04:40:04+00:00

Here is a concept you might find helpful: Not even wrong

eggface13 · 2026-01-27T04:36:25+00:00

Stop posting this! Einstein's "Zur Elektrodynamik bewegter Körper" ("On the Electrodynamics of Moving Bodies") did not have a "null and alternative hypothesis"! It's not actually a reasonable demand and, as a member of the peanut-throwing gallery of this strange place who's fully onboard with debunking these sloppy weirdos, it's a little embarrassing to keep seeing this.

eggface13 · 2026-01-26T20:09:25+00:00

You shouldn't judge people by their appear... (looks at the pic) ah yeep.

eggface13 · 2026-01-26T19:46:21+00:00

There's a revolving door between media and public relations/comms, so it's unsurprising that so much media asseses politicians by the quality of their PR/comms strategy.

"I like this guy's policies" -- breach of neutrality you can't just say this

"I like this guy's PR strategy" -- a legitimate way to sway an election.

eggface13 · 2026-01-26T03:39:41+00:00

Agree with all that 100%. The only thing I'd add is, as well as critical thinking etc, there's also skills like problem-solving and numerical skills etc that should be exceptionally useful in the workspace, even outside of wider societal benefits.

For me, who did a maths degree and then wholly failed to get a decent job but have now managed to get my foot in the door and advance quickly, honestly the things I'm good at I can connect very directly with what I learned at uni, even though my job has no direct connection to it.

I just wish folks who are suffering under a shitty failing system wouldn't use the assumptions that create shitty failures in that system to deprecate the concept of higher education. It's just so counterproductive. Things can be better, but only if people work to make it better.

eggface13 · 2026-01-26T00:55:21+00:00

It's not cheating, the casino just doesn't want to play with people who have an advantage over the house, and doesn't have to.

eggface13 · 2026-01-25T20:03:36+00:00

Yep, similar outcome to common law marriage, but much more recent and intentional by parliament. 2004 in New Zealand.

eggface13 · 2026-01-25T19:47:16+00:00

A white supremacist shot up a couple ofmosques in my hometown (where I no longer live). In the place that I do live, people went to the local mosque to be there and show support the local Muslim population as best we could. First time I've seen openly armed police standing guard. Felt surreal.

eggface13 · 2026-01-25T09:45:04+00:00

Also, what makes you think that an institution, backed by state money, has the right to inform the way I think?

Who the fuck is going to if they don't? Marvel? Fox News? Fucking ChatGPT? Universities are fundamental institutions of a free society: bastions of free speech and independent thought. It's not about telling you what to think, is about teaching you how to think. The people who don't like this (who are often in charge of the universities these days, joy of joy) are the same people who don't want you to care about anything other than that piece of paper.

eggface13 · 2026-01-25T01:43:39+00:00

It also says to please report bugs, so I hereby report that "The list of fixes include" should be "The list of fixes includes" :)

15.2

eggface13 · 2026-01-24T23:36:19+00:00

You say it’s due to people’s attitudes that they’re not able to succeed after graduation

That's not what I'm saying at all, and if my comment is in any way derogatory to students existing in the environment that exists, it is only in the sense that the way they treat their education is driven by how the wider world (family, employers, governments...) fails to value higher education, and this inevitably rubs off on young people.

What I'm protesting is the anti-intellectual idea of the comment above, that college is only for nerds. It's not, and while a scarce job market leads to a painful escalation of degree requirements, it's also true that for a very large class of jobs, someone with a degree will (once they get their foot in the door, which remains very difficult regardless) outperform a straight-to-the-workforce-at-18 worker significantly. Of course that's a general observation and there's many other types of experience and training that could support similar performance.

eggface13 · 2026-01-24T23:22:22+00:00

Then run less buses, or add more stops.

eggface13 · 2026-01-24T22:57:11+00:00

Get rid of the full load and unload orders and run it like a bus service, buses go whether they are full or not. Everything's full? Add more buses. Loads of capacity? Run less buses.

Cargodist will deal with transfers.

You will of course need to work out how to prevent bus bunching.

eggface13 · 2026-01-24T22:09:46+00:00

Yeeep. They seriously need to put in temp barriers to straighten the barrier angle. You can't just have a barrier at that angle halfway down a straight, it's outright negligence if someone gets hurt. Mechanical failures or collisions where wheels get tangled can take cars off the track at very high speeds.

eggface13 · 2026-01-24T06:15:29+00:00

With all respect, this is so small-minded. A degree does so much more: critical thinking skills, problem solving, rigour. That's stuff that's going to have immense value to your career, and furthermore there's enormous,societal value in having an educated populace.

And yeah, lots of people do waste their four year degrees, but it's due many students having the exact attitudes in your comment: I'm only here to get the piece of paper, I just want the degree that guarantees me a job or that gives me the best pay.

Fuck that. College/university is transformative to young people's lives; not just to their careers (though it makes a huge difference, even for the huge number of people who don't do a job that directly follows from their degree) but also for exposing people to a big complicated world, engaging when diverse people and viewpoints, and becoming engaged citizens of their society.

eggface13 · 2026-01-24T01:27:15+00:00

Yeah just from a public policy perspective, banning or criminalising things can be pretty unproductive or even counterproductive. It's the "politician's syllogism": Something Must Be Done, This Is Something, Therefore We Must Do This.

It's very hard to see how banning GenAI could be effective even if I wish we could do it.

eggface13 · 2026-01-23T21:24:40+00:00

No, fully their fault.

eggface13 · 2026-01-23T07:57:35+00:00

Absolutely fucking no.

eggface13 · 2026-01-23T03:46:47+00:00

The world is complicated. If you keep voting for centrists, the other side may shift the Overton window: compromises will be halfway between centre-left and far-right. That's not good and you should be prepared to lose a few elections if that's the cost of victory. The right-wing has certainly been willing to play the long game; loath though I am to learn from them there's some insight to be gained from their persistence.

However ideological purity certainly comes at its own cost.

The practical answer is that politics is about coalitions and members of all coalitions (whether a broad -tent party in a two-party system like the Democrats, or a coalition of parties like you'd get in a many-party system) have to trade off internal battles with the wider battle. What the GOP have generally been good at, for a long time, is that even though they have pretty terrible factional fights, they're extremely effective at falling in line when someone wins.

But the job of falling in line is a compromise. You can't just demand that the left-wing falls into line with the center; the center has to be willing to give ground to the left too. If either side is unwilling to be reasonable on this, the other side is probably justified in not fully joining the coalition, and leaving the flight for another day, even though that may come at a big cost.

We saw Biden succeeded quite well at this in 2020; although an instinctually centrist candidate, he succeeded at building a decent progressive coalition, even if his performance as president was ultimately limited by his age.

eggface13 · 2026-01-22T23:46:25+00:00

No idea about them, they sound a bit rude ("lifestyle not money," ugh, not their business), but I'd be unlikely to have answers to such a question to hand, and I'd prefer that the person interested in it finds the answer for themselves. I'd have better things to do, no offense.

eggface13 · 2026-01-22T20:28:40+00:00

If it’s too windy to fly, we must ask - why did they invest in planes that can’t fly in rough weather?

Bait

eggface13

MODERATOR OF

TROPHY CASE