+- Swisslog's Forum (https://www.swisslogforwindows.com/forum)
+-- Forum: Swisslog version 5.x (https://www.swisslogforwindows.com/forum/forumdisplay.php?fid=3)
+--- Forum: General discussion (https://www.swisslogforwindows.com/forum/forumdisplay.php?fid=4)
+--- Thread: Power Query Questions (/showthread.php?tid=1272)
Power Query Questions - do5rbb - 07-07-2025
Hello together,
I have 2 questions about Power Query, because I can't get any further despite many attempts.
How can I filter all callsigns that have more than 6 characters?
In the “SQL” tab I can enter a WHERE condition with the length of the call ( LEN(QSO.L_Call) > 6 ). The preview is then also correct, but this cannot be saved. The “QUERY” tab then shows something different or invalid.
Furthermore, I would like to insert a counter in the first column, which numbers the rows consecutively.
Does anyone here have an idea how this works?
73, Ralf
RE: Power Query Questions - EA3GCV - 08-07-2025
Hi Ralf,
I'm out of home this week. I will give you a reply as soon as I can play around with this in the Power Query.
73