Load distinct

[soniasweety]

Hi all,

if do load distinct in script  will it effect to qvw performance ?

load Distinct

product,

orders,

sales,

......

from   .... qvd;

thanks

Sony

[balabhaskarqlik · Accepted solution]

Yes, Definitely, it'll improve performance.

Join and concatenate, outputs most of the records from data source.

It'll remove Duplicate records from input as well as Output. Records count is less.

So, when using Distinct, should have a temp table.,

Refer this:

http://www.qlikfix.com/2013/07/30/distinct-can-be-deceiving/

[arvind_patil]

Hi Sony,

If your table has duplicate records then only it helps. or else it takes time same as previous one.

Thanks,

Arvind Patil