topic Error while loading the data...?? plz help in QlikView

Error while loading the data...?? plz help

vishalgoud — Fri, 20 Nov 2020 18:02:30 GMT

hi All ,

I Have 2 tables related to Count , and one is in normal Excel form but other is delimited form am trying to load these second table in Qv server setup..

it is taking all the fields in a single row with commas(,) and when an trying it reload it is giving an error...

what is the Solution to load it normally or is their any way to covert it into normal excel form , plz respond

thanks In advance....

Re: Error while loading the data...?? plz help

Fri, 20 Feb 2015 09:02:04 GMT

Hi Vishal,

you might want to expand on your issue a bit more than that, posting up an example of your code or attach an example application is a good start. You'll find troubleshooting your issue much easier for community member then.

Re: Error while loading the data...?? plz help

timanshu — Fri, 20 Feb 2015 09:16:48 GMT

Hi,

When you Load Files , then there is a option of :File Type" on left side.Check Delimited option there and select the delimiter for the file

Re: Error while loading the data...?? plz help

Anonymous — Fri, 20 Feb 2015 09:21:50 GMT

try to save your excel file in .csv format then load

Re: Error while loading the data...?? plz help

Anonymous — Fri, 20 Feb 2015 09:22:29 GMT

or you can directly replace all the (,) in excel with blank