Hi! I'm quite new in the qlik "world", i've uploaded some data from my database to a table on the qlik cloud, and we have developed some graphs with them. all pretty nice, compared to the excel that we were using before.
But i've not understood some things on how qlik manages the data tables.
Everyday i upload (with the data loader) the last year of data from a table, as every day there are new rows and also some changes or deletes on rows already present on the qlik version of the table.
What worry me is how qlik is able to "match" the rows without knowing what are the key fields of the source/destination tables.
That would depend on your data model. By default, a reload drops all existing data and creates it from scratch. If you've written some sort of incremental load script, though, that would not be the case .
Uhm, how i can check it? I'm trying to check the number of rows, on the table generated by my system i have 27124 rows, on the qlik table i have 22582 rows. I have a scheduled job that prepare the data, and load them on a table, that is the same table used by the datatrasfer utility.
It's already a bit strange that the 2 numbers aren't the same.
If you did not specifically create an incremental script, it should be a full reload from scratch. If you don't know how to check this, odds are you didn't specifically create an incremental script...
See the documentation for information on Partial Reloads:
There's plenty of how-to and tutorials on getting started with Qlik Sense, a quick search should turn up a bunch in video or text format based on your preference.
I don't use DataTransfer so I couldn't really tell you anything about that.
Yes, there are out a lot of documentation about qlik sense, but not too much about the data trasnfer utility, and how it upload the tables (as qvd files) on the cloud.
