2 Replies Latest reply: Nov 21, 2012 4:28 AM by Dave Riley RSS

    Qlikview eliminating duplicate lines when loading from CSV file?

      Hi all,

       

      I have the below code:

       

      -----------------------------

      LOAD @1 as [Reporting Entity],

           @2 as UBR,

           @3 as FSI,

           @15 as [Group Settlement Amount],

           @18 as Description,

           @19 as [Receiving FSI],

           @21 as Period

      FROM

      [C:\PATSYS50\Folder\FILE.csv]

      (txt, codepage is 1252, no labels, delimiter is ';', msq, header is 1 lines);

      ------------------------------

       

      I have a CSV file with a content below:

       

      V4.0;GL;R;Delta;IF;;11-19-2012;10985;100

      8423;7052;1770111000;;;;;;;;;;;;2726.94;;;6520_FILE000154_rajwlal_20121119;1770109000;;201101

      8423;7052;1770111000;;;;;;;;;;;;2726.94;;;6520_FILE000154_rajwlal_20121119;1770109000;;201101

      8423;7052;1770111000;;;;;;;;;;;;2726.94;;;6520_FILE000154_rajwlal_20121119;1770109000;;201101

      8423;7052;1770111000;;;;;;;;;;;;2726.94;;;6520_FILE000154_rajwlal_20121119;1770109000;;201101

      8423;7052;1770111000;;;;;;;;;;;;2726.94;;;6520_FILE000154_rajwlal_20121119;1770109000;;201101

      8423;7052;1770111000;;;;;;;;;;;;2726.94;;;6520_FILE000154_rajwlal_20121119;1770109000;;201101

      8423;7052;1770111000;;;;;;;;;;;;2726.94;;;6520_FILE000154_rajwlal_20121119;1770109000;;201101

      8423;7052;1770111000;;;;;;;;;;;;2726.94;;;6520_FILE000154_rajwlal_20121119;1770109000;;201101

      8423;7052;1770111000;;;;;;;;;;;;2726.94;;;6520_FILE000154_rajwlal_20121119;1770109000;;201101

      8423;7052;1770111000;;;;;;;;;;;;2726.94;;;6520_FILE000154_rajwlal_20121119;1770109000;;201101

       

       

       

      When I constructed a table box, there is only 1 row appearing. This leads me to believe that qlikview is automatically eliminating duplicates when loading?

       

      If this is correct, is there a way to reconfigure this so that Qlikview loads the data as it is e.g. all the 10 rows above?

       

      Thanks