Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Mattia
Creator II
Creator II

Why QV duplicate records after data import?

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

Labels (4)
2 Replies
Frank_Hartmann
Master II
Master II

please share script and/or rawdata

Mattia
Creator II
Creator II
Author

Hi Frank,

i've solved the problem.

Thanks,

Mattia