Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

adoteykwame
Contributor

Issues loading from Microsoft Excel Comma separated Value File

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

8 Replies
adoteykwame
Contributor

Re: Issues loading from Microsoft Excel Comma separated Value File

Capture.PNG

adoteykwame
Contributor

Re: Issues loading from Microsoft Excel Comma separated Value File

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

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


talk is cheap, supply exceeds demand
adoteykwame
Contributor

Re: Issues loading from Microsoft Excel Comma separated Value File

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,

thanstad
New Contributor III

Re: Issues loading from Microsoft Excel Comma separated Value File

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

adoteykwame
Contributor

Re: Issues loading from Microsoft Excel Comma separated Value File

Kindly shed light on that fucntion. Thanks

thanstad
New Contributor III

Re: Issues loading from Microsoft Excel Comma separated Value File

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.

adoteykwame
Contributor

Re: Issues loading from Microsoft Excel Comma separated Value File

Thanks.

Community Browser