|
Power Query Questions
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
|
