Can we transpose a table output

Queries and Resources
,
1

Hello,
I have multiple sql queries , which were transformed to data array and then joined using another sql query.

  1. Do we have any way to transpose the output of the joined query ?
  2. Will the transpose work with custom columns ?
2

Hey @Nitish!

Happy to help here! So are you looking to pivot your table? If so, depending on your resource type you may have access to a PIVOT function (link to docs here). Otherwise, you should be able to achieve this with a JS transformer (link to docs here), to transform the shape of your query data. Do you think either of these could work for your use case here?