Search results for:

https://www.instagram.com/reel/DDCLLHMPKOG/?igsh=cThlanNhZWpqdnph

Cheers. I should probably double check if I've got another.

At this stage they would be sacrificial.

Cheers. I'll give that a go to start.

I even had a dream that I found a tape to use.

I'm hoping my folks bring a tape, as the only tape I have is an ancient hop mix tape with sentimental value that has been cut and taped back together and transplanted into a screw together case. I still haven't noted down the tracks and build a Spotify Playlist from it due to the lack of a player.

I guess now with shazam what would have once been a faff is actually ridiculously easy.

Also @hugo7 for this extensive video
https://youtu.be/4ylOWFczexc

Found this. Will hunt down Techmoan. https://youtu.be/onFTs_Dt2ac?si=-H-2vM1OVST7cROk

Agreed on not paying someone.

Is Sanyo Scottish slang for something?

I was thinking about a tape cassette player for my eldest and my folks have this old Sanyo Slim 5(?). With the issues outlined by my dad below.

What's my best approach with this? Anyone know any good resources for information or spares?

... the heads turn but do not feed so build up around the left hand head last photo.... The sound grumbled out but stopped because of the winding mechanism. Perhaps could be serviced. The electric motor and keys work, I blew out dust & wiped the outside. So problem is heads & playing.

Sorry for being a dick about it.

TBH I wouldn't have expected a high basic as surely with that sort of job it's all on the backend.

What. The. Actual. Fuck.

I've gone back to Excel and all my formulas return "0".

Genuinely about to loose it now.

Definitely a good lesson in not trying anything new unless you have bags of free time.

Edit Restarted everything and it seems to be back to normal

That's quite a good one.

I'm still so disappointed by how shit my first one was I haven't had the heart to look into it again.

Difference in the quotes is about £1,600.

What is that as a %?

This is one of the best things I've seen in a long time.

Explains why we're all wankers.

What are you trying to do?

The same excerses as before - 1. identifying mismatching pairs, 2. work out the correct value for 'field X' in the mismatched pair, 3. Fill an upload sheet with different named headers so it can be sent for remediation.

Why are you joining these two CSVs?

The "Report" is made up of these two CSVs - reportdateA = the first 70k rows, reportdatea = the next 69kish rows.

So I could do the UID and column deletes in both, the lookup for 'field X' has to be in a combined sheet.

I also need to do some other filters like when field x for a particular role has a date <today then ignore, and flag when certain columns = 'yes' with some other conditions.

NABIYE Car Roof Bag. Foldable waterproof roof box.

https://www.amazon.co.uk/dp/B09T34CMH9

Used for one trip, then my folks gave us their roof box when their car was written off.

I like it as it packs down small - about the dimensions of a 27" monitor but fatter.

Size 38" x 38" x 18"
Weight 3.9kg

.

I just need to do a YouTube course / tutorial as this is just not working for me.

I have:

1. Joined 2 csv (same headers, c.140k rows x 77 columns)
   
2. Removed some columns
   
3. Added some columns concat'ing other columns for UIDs
   
4. Made a flag when a date in one column is older than today
   
5. Removed duplicates from a new UID column
   
6. Removed a column I sort of wanted which contains numbers and blanks where the numbers are whole and to 1 decimal point, because I'm getting an error ( [DataFormat.Error] We couldn't convert to Number) when I try and close and load that says it can't convert the numbers.
   
   

But the whole thing won't load (black=what I want, red=source, purple=removed column I thought was the problem)

It feels like there is a fundamental concept I am missing about how PQ works. I literally just want the sheet for the work I've done thus far so I can do my lookups as I'm getting no where. But now I can't even do that.

I was hoping I'd be able to do 90% of my steps on this stupid massive sheet to get it down to a manageable size, while also having each step neatly labeled and also being able to copy the code from the Advanced Editor so I can perform all these steps again with new data ( the 2 source csv have a consistent name with each days date).

Now thoroughly depressed. But have also locked onto it and am struggling to let it go.

When you open your power query and look at the data transformation view, the "profile from 1000 rows" is in the bottom left corner.

All this is greyed out.

I'm going to have one more run then start again

Actually no. Starting again is better.

On the tstak chat from a few pages back. Got round to getting one to house my router and Multi-Tool. It's got an SSD insert, but I think I'll make my own out of foam.

Got to say I'm impressed at how solid they are. As they're the lower end, rather than the Tough System, I didn't expect them to be as solid, but they're more than ample for my diy needs. Tbh my original drill driver box is even less solid yet is still perfect after 9yrs.

Have you got anything good?

I'll see if I can find that option.

I swear my current version of PQ looks more stripped down than it used to. I have also lost the PQ tab like this:

And only have it as option within data (I think).

There have been efficiency drives so I wonder if they've scaled back the office package or something. Likewise, I could be paranoid but I think they've reduced the number or processors(?) or something on my VM. My ram is the same but I'm routinely maxing out my machine using xls.

Yes.

Yes. I need a few number text concatenations. But I thought Text.From(xxx) would deal with it.

Now I have a sort of grasp of what I'm doing I'm going to start again.

Being able to tidy up and remove the unnecessary columns without xls crashing has been a real game changer.

And I'm hoping by copying that detailed view thing I can copy and save that to re-run all these early steps.

Unfortunately where I really struggle is with more detailed formulas - e.g. I want to look for a matching UID against the whole colum of UID where the value of another column = "hamster" then when there is >1 result concat those with a ; delimiter. In excel I can just about work it out, but 0

It says there is an error in A537 but my version is locked to display a certain amount of KB so I can't get more rows.

Going round in circles with PQ.

When I try and load i get

[dataformaterror] we couldn't convert to Number

How do I identify the problem area?

Basically I've deleted a load of columns and added some new concat columns, but I swear to god I've been through all of those to check they're packed full of Text.From

I was hoping to load at this point because the sheet should be more manageable and I can't get my if lookup to return a result in PQ.