topic Re: Not Import Double Rows in QlikView https://community.qlik.com/t5/QlikView/Not-Import-Double-Rows/m-p/446058#M166391 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>did you try with <STRONG>load distinct...</STRONG></P></BODY></HTML> Mon, 19 Nov 2012 12:17:42 GMT 2012-11-19T12:17:42Z Not Import Double Rows https://community.qlik.com/t5/QlikView/Not-Import-Double-Rows/m-p/446057#M166390 <HTML><HEAD></HEAD><BODY><P style="background: #8cbede;"><EM style="font-size: 10pt; font-family: Verdana;">Hello all, <BR /><BR />It Is possible to import a file that the double rows not import in QlikView? <BR /><BR />With friendly regards, <BR /><BR />Hans </EM></P></BODY></HTML> Mon, 19 Nov 2012 12:14:57 GMT https://community.qlik.com/t5/QlikView/Not-Import-Double-Rows/m-p/446057#M166390 2012-11-19T12:14:57Z Re: Not Import Double Rows https://community.qlik.com/t5/QlikView/Not-Import-Double-Rows/m-p/446058#M166391 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>did you try with <STRONG>load distinct...</STRONG></P></BODY></HTML> Mon, 19 Nov 2012 12:17:42 GMT https://community.qlik.com/t5/QlikView/Not-Import-Double-Rows/m-p/446058#M166391 2012-11-19T12:17:42Z Re: Not Import Double Rows https://community.qlik.com/t5/QlikView/Not-Import-Double-Rows/m-p/446059#M166392 <HTML><HEAD></HEAD><BODY><P>If you are loading double rows, then it probably means that there is something wrong with the data in Qlikview. If you are going from SQL, then as Krunoslav has suggested, you need a SQL SELECT DISTINCT * FROM table at the beginning of the statement,</P><P></P><P>Kind Regards,</P><P></P><P>Miles</P></BODY></HTML> Mon, 19 Nov 2012 12:19:45 GMT https://community.qlik.com/t5/QlikView/Not-Import-Double-Rows/m-p/446059#M166392 2012-11-19T12:19:45Z Re: Not Import Double Rows https://community.qlik.com/t5/QlikView/Not-Import-Double-Rows/m-p/446060#M166393 <HTML><HEAD></HEAD><BODY><P>Hello all, </P><P></P><P></P><P>It is true that I have duplicate rules come back, that is indeed a problem in the source data. With the code <STRONG>load distinct </STRONG>I can fix this in QV.</P><P></P><P></P><P>Thanks! </P><P><BR />With friendly regards, </P><P></P><P></P><P>Hans Steenhuis</P></BODY></HTML> Tue, 20 Nov 2012 08:45:39 GMT https://community.qlik.com/t5/QlikView/Not-Import-Double-Rows/m-p/446060#M166393 2012-11-20T08:45:39Z