Skip to Main Content

Pivot for undefined number of columns

PericlesSep 14 2022

I'm trying to make a query to show the results of a survey. Each question has an axis of analysis which is used to consolidate the different answers, and each answer has a weight.
The number of axis evaluated in each survey can vary.
I'm using the PIVOT clause, and even the query is working, and I'm getting the results for an specific Survey, so far I couldn't figure it out how to remove the elements in the for-in.
image.pngChecking the documentation there is the option to use the wildcard any or a subquery
but it is not working
image.pngimage.pngWonder if anyone know why this error is being generated.

This post has been answered by Frank Kulash on Sep 14 2022
Jump to Answer
Post Details
Added on Sep 14 2022