In my previous post, I discussed about getting the result set which lies between the given date range. This time, let’s take an another interesting example, wherein we need to transform the number to rows into number of columns as our result set.
Consider below data for which we need to write query:
Generate result set in such a way that there should be exactly one row for each Feature.
Now if you run the query, you will get the below output:
In terms of expectation, the result looks good, but let’s make it more readable by moving location and version next to each other.
This can be achieved by appending another pipe for project-reorder and it would change our query to something like this:
Now, if you run above query, you will see the output as shown below:
I hope you enjoyed this data transformation query.