Query to get children and parents
The data from RM is normal consider "Clean" data and requires minimal clean-up per say. However, one of Power Queries strengths are in transform and per-filtering was well as merging & appending data & tables.
(for those who are not aware).
Kevin
Quote from Mark Whidby on 2025-01-02, 10:57 am...it was an interpreter issue. I've been using SQLiteStudio. When I tried my query in SQLite Expert, it worked just fine.
Maybe you need to install the latest version 3.4.13 of SQLiteStudio. I was using until a few minutes ago 3.4.4 and your script worked as it should on both versions. Maybe you had an earlier version or your installation was defective. It would be troubling for many users if your valid and not terribly complicated query would not work as it could spell trouble for many others.
I was using 3.4.10 and just upgraded to 3.3.13. Lo and behold! My query works fine now. I had just upgraded last week and didn't think to look for a newer version this soon. Thx!