Grid widget, dynamic Datashape from Query service

[MichalC]

Hello,

I have a SQL Query service where, see attached for sample SQL result set

The columns headers will change daily, how to make it dynamic?

Thanks

[Ascherer17 · Accepted solution]

If you simply need to show all the data that comes from the query, you can feed it into the Grid widget and set 'ShowAllColumns' on the widget.  If you need to manipulate the data in the Grid or only show certain columns, you'll need something more complicated.