What happened to the PIVOT feature in the Kinetic BAQ?
I’m trying to create a BAQ that would include a Pivot with Dynamic values instead of selected, so the classic version does not work.
Huh! Is that a thing that actually existed in BAQ? I’ve never seen a SQL editor try to do that before.
PIVOT is the same in classic and Kinetic. No dynamic values. BAQ consumers need to know what columnsa are exactly returned
1 Like
I don’t believe you were ever able to pivot with dynamic values. This is how you set the pivot, and you do the same basic thing you did in classic.
From what I understand, SQL doesn’t have any kind of built in dynamic pivot like people are used to with excel. So to get that in SQL, you would need a pretty complicated query. the BAQ editor isn’t going to have that level of control to make a dynamic pivot.
Now if someone can prove me wrong, I would love that!
Thanks Brandon! That is what I was looking for.
And I haven’t heard of SQL with dynamic value pivoting either, was just throwing it out there.
Appreciate the help!
1 Like