topic Does resident keyword create duplicate entries? in QlikView

Does resident keyword create duplicate entries?

Fri, 30 Dec 2011 09:49:32 GMT

I've the following script in Qlikview:

FinalOutput: select emp_id from employees;

Load * resident FinalOutput;

store FinalOutput into FinalOutput1(qvd);

Will the above

Load * resident FinalOutput

statement create duplicate entries in the output file

FinalOutput1?

Does resident keyword create duplicate entries?

SunilChauhan — Fri, 30 Dec 2011 10:09:20 GMT

resident will not create any duplicates value .

you need to drop your base table.

Does resident keyword create duplicate entries?

Fri, 30 Dec 2011 10:14:55 GMT

Thanks Sunil,

How can I get the count of records in FinalOutput1(qvd)?

Does resident keyword create duplicate entries?

SunilChauhan — Fri, 30 Dec 2011 10:17:11 GMT

Load

from qvd

let var=noofrows('Tablename');

now use =$(var) in text box

Does resident keyword create duplicate entries?

Fri, 30 Dec 2011 10:34:18 GMT

Thanks,

Will Load Count(*) from <path>/FinalOutput1(qvd); work for counting the no. of records?

Will result be the same as with yours?

Does resident keyword create duplicate entries?

Fri, 30 Dec 2011 10:38:14 GMT

Qlikview is autoconcatenating your new table into the base table. To prevent it use noconcatenate keyword before load keyword while loading second table.

you can use count() function but in your case best will be just to use rowno() as rownum in your 2nd table while loading and then you can get count of records in a variable by using

let v_row_count = peek('rownum');

it will stop autoconcatenation also. but remember to drop your base table otherwise you will get synthetic keys.

hope this makes sense.

Regards,

Ashutosh

Does resident keyword create duplicate entries?

Fri, 30 Dec 2011 10:49:15 GMT

Thanks Ashutosh,

By new table and base table do you mean FinalOutput1 and FinalOutput resp.?

what is the second table that you are referring to?
Can you plz post the entire script...

Thanks,

Does resident keyword create duplicate entries?

Fri, 30 Dec 2011 10:58:05 GMT

second table is the new table which you made using resident.

script can be as

t1:

load

from abc.qvd(qvd);

t2:

load

rowno() as rownum

resident t1;

let v_row_count_t2 = peek('rownum');

drop table t1;

drop field rownum;

Regards,

Ashutosh

Does resident keyword create duplicate entries?

SunilChauhan — Fri, 30 Dec 2011 11:34:04 GMT

yes its work same

but in your count(*) needs to add group by