Why QV duplicate records after data import?

Mattia — Sat, 16 Nov 2024 19:50:39 GMT

Hi Guys,

i've a new problem on QV.

i've imported more txt files, called "T" and "D", that refers to different STRUCTURE. The key field between "T" and "D" is called "CONTATORE". All the files "T" and all the files "D" have the same fields and QV automatically treats the next tables as a continuation of the first "T" and the first "D".

But, when i create a straight table whit some of these uploaded fields (from "T" and "D") and a calculated new field ("VALUE"), QV duplicate some records, that have the same key field.

E.g. txt file "STRUCTURE1" shows only 1 record for "CONTATORE" ABC01234 and txt file "STRUCTURE2" shows only 1 record for "CONTATORE" ABC01234 but, after the import, i've 2 records for each structure and also the calculated field "VALUE" is duplicate and i don't know why.

Please, someone can help me?

Thanks,

Mattia

Re: Why QV duplicate records after data import?

Frank_Hartmann — Tue, 22 Oct 2019 13:39:05 GMT

please share script and/or rawdata

Re: Why QV duplicate records after data import?

Mattia — Tue, 22 Oct 2019 14:50:55 GMT

Hi Frank,

i've solved the problem.

Thanks,

Mattia

topic Re: Why QV duplicate records after data import? in QlikView

Why QV duplicate records after data import?

Re: Why QV duplicate records after data import?

Re: Why QV duplicate records after data import?