Forum

Hi k s, You can't load a PQ transformed table back on top of the original source table. The whole idea with PQ is that you connect to a source and ...

I created 12 separate queries like you, and they all pick-up the data from each of the files. When I looked at your video I notice that you worked off...

Hi Job, It's difficult to diagnose such a query without having some data to play with. No need to share thousands of rows, but could you upload a fil...

Oh! Sorry about that. It seems I missed the Upload button myself this time 🙁

Okay! Since you work with texts rather than real dates you can't just scan the Year column for the "latest date". I added a small query that just take...

The number -1.4210854715202E-14 is not an error. It's just a very very small number, very close to zero. Change the format of column F to Number with ...

Sorry, but I don't understand. I merely followed your example. How would you do the lookup in Excel for, let's say two out of three years? Perhaps you...

Without seeing some of your own data it's difficult to come-up with a proper answer. But perhaps you find the example in the attached file useful. In ...

I like to keep thing simple. And because you don't work with real dates, I added a column to the lookup table for the year "22-23". Then you can easil...

In MS365, that would be: =TEXTJOIN(", ",,FILTER(names,ISNUMBER(SEARCH(names,A2)))) where "names" is a named range containing the list of names. ...

I guess that's possible, but to save me from having to guess how your tables and data are structured and exactly what to look-up from where, please up...

Data is nothing more than the "TransformColumnType" step renamed to something more friendly. I used the step name later on when I do a Merge. but now ...

See if the attached example does what you need. By the way, it assumes you have one text column and all others contain the monthly data.

It's not an error. Just a message saying that the preview may be a few days old. If you are insecure, save your work first and then press refresh and ...

I find it difficult to visualise the issue. Can you please attach a file with dates and describe what each of these represent? I can make some assumpt...