Solved: Merging two same QVD's with set of same records - Qlik Community

Anonymous · ‎2016-02-03

Hi,

I am trying to merge two same QVD's with set of same of records. After reloading that script, I am able to see double the records in that QVD. But in table box chart when pulling all columns, it is displaying only 10 records.

My doubt is when concatenate same QVD with set of same records, will double that record count in QVD.

sunny_talwar · ‎2016-02-03

You can create a ID field by Concatenating all your 10 fields in that case:

test:

LOAD *,

AutoNumber(Field1&'|'&Field2&'|'.....) as ID

from events.QVD

concatenate

load*from events.QVD

Where not Exists(ID, AutoNumber(Field1&'|'&Field2&'|'.....));

store test into path\events.QVD

View solution in original post

sunny_talwar · ‎2016-02-03

Table box only show the unique combination of selected fields. To see the actual data count check the count from Table Viewer (Ctrl + T)

PrashantSangle · ‎2016-02-03

Hi,

Yes,

for cross check take listbox with any field and check its frequency.

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Colin-Albert · ‎2016-02-03

A table box only shows the unique rows in the selected fields is does not show all rows, unless each row has a unique identifier.

Anonymous · ‎2016-02-03

Thanks for your Quick reply Sunny

Bu I want to see unique records, I mean no duplicate. Is there any way to resolve this duplicate records.

Chanty4u · ‎2016-02-03

use joins...left join

PrashantSangle · ‎2016-02-03

Hi,

If you want unique records then why are you concatenate same QVD with same set of records again??

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

sunny_talwar · ‎2016-02-03

May be you can do a resident load with DISTINCT in the script before saving the data to a qvd?

Anonymous · ‎2016-02-03

Thanks,

Can't we use inner or right join. why only left?

Anonymous · ‎2016-02-03

This is how I am doing.

test:

load * from events.QVD

concatenate

load*from events.QVD

store test into path\events.QVD