topic Issues loading from Microsoft Excel Comma separated Value File in QlikView

Issues loading from Microsoft Excel Comma separated Value File

Anonymous — Wed, 26 Sep 2012 09:02:09 GMT

Hi ,

I'm really struggling to load data from the above format i.e. Field not found but however when i comment those specific fields the script executes successfully.

Please! Help

Re: Issues loading from Microsoft Excel Comma separated Value File

Anonymous — Wed, 26 Sep 2012 09:13:23 GMT

Re: Issues loading from Microsoft Excel Comma separated Value File

Anonymous — Wed, 26 Sep 2012 11:27:30 GMT

When i comment the following fields in the square brackets the scritp runs.

[ PRINC-AMOUNT ]

[ PRINC-BALANCE ]

[ ARREARS TOTAL]

Now i wondering could it be how the data was captured? Besides the above fields data type is currency(Money)

Re: Issues loading from Microsoft Excel Comma separated Value File

Gysbert_Wassenaar — Thu, 27 Sep 2012 09:18:35 GMT

Does it work if you remove the leading and trailing spaces from the field names in both the csv file and your load script?

Re: Issues loading from Microsoft Excel Comma separated Value File

Anonymous — Thu, 27 Sep 2012 10:57:17 GMT

I guess it's the formatting in the csv file, so i copied that file and pasted only the values (paste options) and now it's executes successfully. Thanks anyway,

Re: Issues loading from Microsoft Excel Comma separated Value File

thanstad — Thu, 27 Sep 2012 11:50:43 GMT

Have you tried the function - SET VERBATIM=1; This function should help you out, dont forget to set the verbatim back to =0 afterwords.

Re: Issues loading from Microsoft Excel Comma separated Value File

Anonymous — Thu, 27 Sep 2012 12:12:30 GMT

Kindly shed light on that fucntion. Thanks

Re: Issues loading from Microsoft Excel Comma separated Value File

thanstad — Thu, 27 Sep 2012 12:56:10 GMT

Well that function helped me in the same problem - If the function ignore the blanks in the fieldnames, Qlikview read at least my file. The alternative where to edit the file and remove the blanks in the fieldnames.

Re: Issues loading from Microsoft Excel Comma separated Value File

Anonymous — Thu, 27 Sep 2012 14:22:42 GMT

Thanks.