Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
dsharmaqv
Creator III
Creator III

All the columns of Excel is not getting Loaded

Hi

I am facing an issue while loading excel in QV. While loading it always loads 100 columns and leave last 3 fields. If I delete any three columns from the start then only it loads last three as well.

Can soume one assist me with the rootcause/resolution of the issue.

I am happy with any work arround as well.

Many thanks in Advanse

Deepak

6 Replies
big_dreams
Creator III
Creator III

can you share script?? and sample file

Regards

dsharmaqv
Creator III
Creator III
Author

Hi max

File size is 300mb it contais 103 columns and half amillion records. Script is very straight forward load nothing else.

big_dreams
Creator III
Creator III

Well I tried with 206 columns and I can load it.

so i am not getting it why you are facing issue??

Regards,

dsharmaqv
Creator III
Creator III
Author

with .5 million records?

olivierrobin
Specialist III
Specialist III

hello

can you post the load statement you use ?

big_dreams
Creator III
Creator III

what was your concern, Is loading huge data or not loading all columns??

300 MB file is not big data for qlik. You can easily load it.

Regards,