Discussion board where members can get started with Qlik Sense.
I have a problem trying to update my data in Qlik sense 2. In previous version there was a option "Replace data", and now does not longer exist. Now only exist the option "Add data", so if I already have data in my report, it will be duplicate my info.
In version 1 you had the possibility to choose if you wanted add or replace data.
In version 2 you don´t have the option. You have to specify directly a data source.
Thanks for your help.
yes, I also have just installed Qlik Sense Desktop v2, and want to revise the data set I've previously used. Actually the question is not so much about upgrading to the new version, but asking how to do a replace data within version 2. My Qlik Sense app uses two different data sources/files, and I have been expanding the elements available in one of them (.csv or .xlsx). Is there a 'replace' function in v 2 that is analogous to the Quick Data Load option of v 1.1?
ADD DATA is in the DATA MANAGER. ADD DATA means adding some extra tables from another source ... you should use the DATA LOAD EDITOR and the LOAD DATA button there ...
Peter, thanks for this quick reply. And nope, I had not seen that "Load Data" button in Data Load Editor window. That said, when I use the Load Data option, I believe I am refreshing the values in the previously structured data set. This is a good thing for when I'm working with a revised set of data; e.g., trends over month data. But I want to be able to add new data elements --along with the values for each record in the data set-- to my QlikSense app. Under v 1.1, I could use the "Replace Data" option (from the quick load menu), and then all prior data --values and elements-- would be replaced with the new file. Yes, I had to load my peripheral files that did not change, but at least I could grab the new fields. I don't know how to do this sort of expansion; i.e., either the same named file with new elements/columns, or a differently named file with different elements/columns. Is this capability included in v 2.0?
When you Add data in Data manager the information is persisted in a separate load model behind the scene, which results in auto-generated script code that you can't edit unless you unlock it.
If you take a pre-2.0 app where you used Quick data load, the information is persisted in the actual data load script code.
That means, in the Data manager, you can change selections and remove data tables you added with Add data, but only view tables that are result of "written" script code from Data load editor.
I would recommend you go to the Data load editor, and delete the script code that's loading the data files, and then use Add data to add them back. After this, you can handle your data sources in Data manager. Replacing files is just a matter of deleting them, and then adding the new file.
This is only true for straight-forward table loads, beyond that you will need to use the data load editor.