Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Is it possible to keep optimized load while performing data transformations?

I understand the difference between optimized vs non optimized loads, and clearly an optimized load is preferred.  However, due to business requirements, data transformations in the script (such as filtering data sets, creating new calculated fields, concatenating fields for keys...etc) are inevitable.  All of these transformations (except the filtering data sets using WHERE exists) force a non optimized load.

Is it possible to (for example) create a calculated field while maintaining an optimized load?

You may say that I should perform the calculations on the database side, store already transformed data into a QVD and then optimize load into a QVW.  However, to maintain flexibility, I chose to perform the transformations at the QlikView level.

Any tips and tricks are appreciated.

Thanks,

Andrew

1 Solution

Accepted Solutions
Employee
Employee

Re: Is it possible to keep optimized load while performing data transformations?

No, every time you make a transformation you loose the 'optimized load'.

An approach is having a 3-tier QVD layer

1) Extracts

2) Do all transformations

3) load optimized

3 Replies
Employee
Employee

Re: Is it possible to keep optimized load while performing data transformations?

No, every time you make a transformation you loose the 'optimized load'.

An approach is having a 3-tier QVD layer

1) Extracts

2) Do all transformations

3) load optimized

kiranmanoharrode
Contributor III

Re: Is it possible to keep optimized load while performing data transformations?

Dear Andrew,

          It is not possible to perform Optimized load while transformation of Data;

Optimized Load is applicable only when, data is fetching from QVD. it is very useful for data filteration with where Exist() fumction.

Regards

Kiran Rode

91 8976977897

Not applicable

Re: Is it possible to keep optimized load while performing data transformations?

Thank you for the response Clever.

This approach is similar to what I been using and unfortunately the answer you gave is what I expected.  If I am to perform transformations, I have to lose optimized load at some point.

Thanks,

Andrew

Community Browser