The Auto-Generated section of the load editor is just encoding what you see on the Data Manager tab.
Do you have access to delete and Add Data in the Data Manager? Because I have self-caused this problem before (In Databricks I changed the schema of some tables and/or renamed tables) and the solution was to delete and then re-add the data source and re-establish the associations. When you do that the Auto Generated Section automatically re-codes correctly.
There is a warning if you go to unlock the auto-generated section! Doing so could fix your problem BUT THEN YOU CANNOT USE THE DATA MANAGER ANYMORE, and it cannot be undone.
The Auto-Generated section of the load editor is just encoding what you see on the Data Manager tab.
Do you have access to delete and Add Data in the Data Manager? Because I have self-caused this problem before (In Databricks I changed the schema of some tables and/or renamed tables) and the solution was to delete and then re-add the data source and re-establish the associations. When you do that the Auto Generated Section automatically re-codes correctly.
There is a warning if you go to unlock the auto-generated section! Doing so could fix your problem BUT THEN YOU CANNOT USE THE DATA MANAGER ANYMORE, and it cannot be undone.
Thanks for this @daturpin ! When you deleted and re-added the data sources on the Data Manager tab, what did that mean for your existing charts? Did they not break?
If I had changed the table name, yes, I also had to correct the expressions in the objects.
If I had only added a column, then no.
It sounds like your tables are unchanged, just the data source location, in which case everything should still work after you reconnect. Note that when you do a connection and load data, what is happening is that tables are being stored locally to Qlik and it is these local tables that the objects are ACTUALLY pulling their data from.
