You are reading a single comment by @aggi and its replies.
Click here to read the full conversation.
-
You've got errors in your source data. You need to sort that out before progressing because you'll just keep carrying the errors through.
Click on the 1,790 errors, work out what is causing the errors, change types or fix some other way on the source, refresh and see if it imports with no errors. If you are still getting errors then repeat. Getting rid of them all can take a few goes. Then do the same for the other source. Get it clean before doing anything else.
aggi
I just need to do a YouTube course / tutorial as this is just not working for me.
I have:
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.