2 Replies Latest reply: Sep 17, 2012 2:53 AM by Jason Michaelides RSS

    Incomplete import of CSV file data to qlikview

      Hi all,

       

      I have the following CSV file data:

       

      V4.0;GL;R;Delta;IF;;09-14-2012;51630;209

      100;3267;1770178000;;;;;;;;;;;;9587.5;;;P_6401_RRIT1010_macajen_20120817;1770423000;;201201

      100;6225;1770178000;;;;;;;;;;;;5162.5;;;P_6401_RRIT1010_macajen_20120817;1770423000;;201201

      100;7957;1770178000;;;;;;;;;;;;-14750;;;P_6401_RRIT1010_macajen_20120817;1770423000;;201201

      100;3267;1770178000;;;;;;;;;;;;9587.5;;;P_6401_RRIT1010_macajen_20120817;1770423000;;201202

      100;6225;1770178000;;;;;;;;;;;;5162.5;;;P_6401_RRIT1010_macajen_20120817;1770423000;;201202

       

       

      I went to EDIT SCRIPT, TABLE FILES, and browsed for this file.

       

      In the file wizard, I can only see up to 9 columns. I suspect this is because the first row line is only up to the 9 column.

       

      But the data I really need are those rows 2 and below. These data are up to 21 columns.

       

      How can I import that entire 21 columns of data based on above CSV file structure?

       

      Thanks in advance.