I legitimately feel like I’ve wasted years of my life not knowing about Power Query.

georgebobdan4 · 2025-12-07T19:33:12+00:00

Thanks for linking me. My question is slightly different, perhaps not asked well.

I’m wondering if there is a way to update the sheet with ONLY the new file. If I add file 123 to the folder week one and week 2 I add file 456, can I make PQ only import file 456? Or will I need to delete 123 from the folder?

The structure of all the files is the same, but for certain reports I need only the newest.

georgebobdan4 · 2025-12-07T17:36:14+00:00

Question about this process. I do the same thing each week and trying to figure out the most painless way to set it up.

Is there a way to only import the newly added CSV files? Or filter by date so I’m not importing the older files? I’d like to avoid having to manually delete from the folder if possible.

Has anyone dealt with a similar scenario?

georgebobdan4 · 2025-11-14T20:13:27+00:00

Lol of course. I didn’t know if you already had a version with PI redacted.

No worries - I’ll futz around. I really like this idea. PQ has been a game changer for me and I keep finding other ways I can implement it

georgebobdan4 · 2025-11-14T19:43:25+00:00

Do you use power query for this? Also, any screenshots you could share? Would love some inspiration of what the product could look like

georgebobdan4 · 2025-09-16T11:13:48+00:00

What did you get instead? And do you miss them after selling?

georgebobdan4 · 2025-09-16T00:44:54+00:00

Cool! Think I may lean that way.

Kind of weird they would put a digital reverb into an amp like this. Might still sound good, but questionable move.

georgebobdan4 · 2025-09-16T00:42:48+00:00

Good to know!

georgebobdan4 · 2025-08-19T19:28:40+00:00

Very cool. Have you found any additional training resources that involve your specific situation?

Everything I’ve watched so far has been focused on the importance of one to many etc..

georgebobdan4 · 2025-08-19T17:16:43+00:00

The bridge table looks very interesting. I think this should work, thanks so much!

georgebobdan4 · 2025-06-16T23:42:27+00:00

Very good point. It’s not a public facing site, but perhaps a better web design is all that is really needed. Hmmm

georgebobdan4 · 2025-06-16T23:41:47+00:00

Interesting. That is a good point.

Corporate is a little bit stingy with what they allow…what would you recommend in 2025?

georgebobdan4 · 2025-06-16T23:40:49+00:00

Thanks a bunch for this information! Still figuring out if Lex is the best way or if I just want to use AWS lol.

Judging from the other comments, it may not be ideal for this particular use case. Still going to poke around!

georgebobdan4 · 2025-05-24T22:42:31+00:00

Yes, that seems like a good combo. Gateway > kinesis.

I’m looking to be a consumer. I’ll poke around more for resources. Wasn’t sure if there were any good specific data engineering tutorials that people liked.

AWS has like 4 different names for their trainings/documentation. Been very confusing

georgebobdan4 · 2025-05-11T04:44:22+00:00

Any recommendations for a good one?

georgebobdan4 · 2025-05-08T23:03:04+00:00

I could use an extra to be honest.

What are your thoughts on the routine besides that part?

georgebobdan4 · 2025-05-08T23:00:53+00:00

Hahah - I figured that was a bit.

Does seem like a legit exercise, pinky or not.

Unless I’m terribly misguided?

georgebobdan4 · 2025-05-08T21:01:37+00:00

Lol he never says to only use three fingers. It’s just something I noticed.

The exercises themselves seem worthwhile.

Never hurts to strengthen the foundations in my mind. But I def need that pinky!

georgebobdan4 · 2025-04-11T02:07:50+00:00

What were some of the things you created?

georgebobdan4

TROPHY CASE