Forum Discussion
Solved
How to show dynamic columns in table ?
so my query is i have one table with 4 columns but in future i will get few more columns so i need to show data in table if new columns get add, i need to show new columns in table dynamically witho...
Hi kavyapriya ,
many connectors add new columns in the source automatically to the query in the query editor.
However, to my experience, this won't automatically be reflected in the data model with the next refresh.
Usually, you have to open the query editor, run the data preview there to see the new column, refresh the data and only then will new columns be added to the data model.
But there might be other experiences with it that I am not aware of.
Hi kavyapriya ,
unpivot (other columns) is the way to go, as you cannot reference any of those "future" columns in the data model today anyway.
So what would be the benefit of loading additional columns that would not be used in the datamodel?