I have the following problem: I have a data table that is fed by data from a SQL query. The query works just fine, but not all the data is displayed. I deleted one of the columns before and no wanted to readd it, but it does not show.
Is there a way to get this to work?
Basically, I have those columns:
Name, First name, birthday, gender
Now I deleted gender:
Name, First name, birthday
After a while, I wanted to readd gender, but the data table shows the following:
Name, first name, birthday
It does work, if I change the column name from gender to sex in the SQL query, but that is not a solution I can live with.
If I change the name, then rename the column header, on the next refresh, the name is reinstated. If I rename the column header, then change the column name in the SQL query, the column disappears on the next refresh.
Anyone with a solution?
I'm guessing you have Preserve column/sort/filter/layout checked in the External Data Properties dialog (right-click> Table> External Data Properties). Try unchecking it, refreshing, and then checking it again. Save first!