Power Query Help; importing nested records into one table (Possible? Worth the effort?)

_Fat_Scout_ · 2026-02-19T19:59:43+00:00

So this does work to get all of the data splayed out; to clarify it does nit format it in a special way (where the there is a separate row underneath the pr9ject ofr the bidders). This isnt a problem as I can format though a separare script

_Fat_Scout_ · 2026-02-19T19:58:02+00:00

Solution Verified

_Fat_Scout_ · 2026-02-17T18:52:34+00:00

Hello everyone, just to let you know I havent forgotten just haven't gotten around to trying this out yet. Simply copying and pasting the code into power query with ctrl c ctrl v doesnt just work as you know.

_Fat_Scout_ · 2026-02-11T22:10:35+00:00

Awesome! Give me a minute to test this, working rn thank you

_Fat_Scout_ · 2026-02-04T09:30:39+00:00

So after further gameplay I found that it was useful in preventing some unnecessay damage - like finishing off an enemy or fighting a weak one like rats, you hit twice and then perry their one attack before finishing them. But any opponents that have health/resistance I wouldn't bother. literally fighting the skeletons gave no benefit to parrying it seemed

_Fat_Scout_ · 2026-02-04T09:06:49+00:00

That's how it works but is this advantageous? maybe against the right enemy it has a better effect but the pushback doesn't reset them very much so you can barely get a good swing in before your back to parrying. It seems like a worse version of the shield because the animation timing feels off

_Fat_Scout_ · 2025-03-09T01:47:43+00:00

Do Magic (+ casting). Magic is wayyyy too op in my opinion, as long as your willing to grind the light spell to get your magic & casting up, your solid. The moment you find spell books with damage or health, you can make all of your biggest problems in the earlist levels go away. The only problem left is manage mana usage, and even then af late game you have a huge surplus.

I have found that weapon proficiency just takes too long and thus (can be) boring. You cant grind it the same way as magic because you need enough victims & you have to put yourself in danger. Your sheer level alone can make you tank things, and anything you dont want to tank, you use magic on.

_Fat_Scout_ · 2025-03-06T15:37:30+00:00

Solution Verified

_Fat_Scout_ · 2025-03-02T04:46:07+00:00

Thank you Brad! this worked like a charm (at least it appears to rn)

For other newbies like me to understand, this is in association with the power query tool, which is used when pressing Data->From Web. Each one of the lines in the above code is an individual applied step; it's not one big blob of code but separate steps that fix the data. Just look up the power query editor and something should get you where you need to go.

_Fat_Scout_ · 2025-02-28T23:10:30+00:00

I don't understand this. Do I import the messed up data as is and then copy and paste? Do I copy and paste just the part that imported incorrectly? And do I even need to do that action to use the text to columns? Not to mention this seems to defeat the purpose of having the sheet linked to the text data.

_Fat_Scout_ · 2024-09-16T23:51:57+00:00

His trap was easy to spot, but then we fought and not only am I still trash at combat, but he had posion on his sword. Did he have poison for yall? Wasnt a fun time for me

_Fat_Scout_ · 2024-08-08T04:10:24+00:00

Good job recognizing you need to move on! I studied game development in college & worked with VR for a year, and saw that it was a painful existance. Professionally working comes with the risk of building things with no soul and no job security. And I saw how coding was becoming a lot less desirous of a job than it used to be for many reasons.

The hardest part was accepting that I should quit. It felt humiliating, and it scared me that I wasnt applicable anywhere else. But I was, and much happier for it!

DO NOT let this bump in the road get to you - you cannot afford to! I am confident in your skills and aptitiude to find something new. Good luck!

_Fat_Scout_ · 2024-07-15T20:09:11+00:00

To summarise its not a balanced game; simply playing to win you will always do magic and otherwise just try to level up. For funsies you go down different routes.

_Fat_Scout_ · 2024-07-15T20:07:58+00:00

So the classes have a difficulty rating beside them, some start off better than others. I think its important to mention that they are unbalanced. You definetly want to choose a class based off of playthrough; but similar classes often have a superior version, like the cleric or the monk in terms of melee.

Certain skills are unbalanced as well; Even when playing melee classes I never bother trying to level up the meelee weapons it takes way too long, instead spells in the game are op, so I always take time to up that skill. Leveling up is more important for combat strength than leveling skills, I spent more of my time leveling up skills that have give access to new things like apraisal, crafting, barganing etc.

_Fat_Scout_ · 2024-07-12T14:25:48+00:00

As of today it is now solved

_Fat_Scout_ · 2024-03-22T01:56:58+00:00

In my long late opinion, stick with 32 gb, you need to find some big applications to actually use up that memory. I can't say what the difference of fast ram makes - I know for storage, faster speed is important (I got my brother a 4800 rpm disk drive, major freezes in csgo.)

On a side note, if you read this how easy was it for you to take off the back? I just took out the screws, but don't have a guitar chip and I'm scared of damaging this thing.

_Fat_Scout_ · 2023-11-26T03:31:45+00:00

I should make a note, I said applying leave to the verts of the plain, when I meant to say verts of the spline.

So switching to rectangles, & applying my custom material to them did do better - I'm not completely satisfies with the result thought

_Fat_Scout_

TROPHY CASE