This app runs server side code to parse the JSON generated with the DataGrid table into the necessary format to display dynamic columns. There is also an equivalent client side action to perform the same JSON Parse. This asset is capable to parse this JSON:
Into this one, ready to be displayed as dynamic columns, according to how many different brands you have on your database:
Which will result in the following datagrid, where data from the database can be used as columns.
The current version of this component has been tested to work with OutSystems DataGrid v2.10.1 (April 2023)
As reported in this post, there was a problem in the logic for dynamic datatypes with boolean values. The asset and the demo were updated to fix this issue and the datagrid be able to display unchecked values.