How to avoid reloading

[#1]

There might be a very simple answer to this.

I've got a table with 18 million rows and am in a process of loading from SQL server to Qlikview.

I would probably need to make changes , rename columns, maybe do some parsing, apply some functions.

Is there a way to do this and apply those changes without have to reload the table?

[krishnacbe · Accepted solution]

Hi,

You can use different layers. First QVW will extract data from SQL server and store it in QVD. In second QVW you can apply your Business Logic.

As you used QVD, it wont take much time to apply all your transformations.