Qlik Community

QlikView Documents

QlikView documentation and resources.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.

LOAD data into QlikView

Not applicable

LOAD data into QlikView

Dear Community,

Please find a new document explaining the LOAD command.

 

This document was first the content of personal notes. It has become bigger and bigger: I just hope it is not too big. it contains 60 pages: let's say that there is almost a tutorial even if there is no exercice.

Basic syntax is first explained but less basic syntax is also reviewed.

Please enjoy ...

Fabrice

PS. compared to version 1, I took into account HIC' comment and added two sections: INPUTFIELD (to enter some data into QlikView) and Generate Random Data (for test purposes)

Labels (2)
Attachments
Comments
chrisg
Partner
Partner

Simply excellent, very useful. Thx

0 Likes
Not applicable

Very helpful. I wish I run into this blog earlier.

0 Likes
vishva2000
Contributor II
Contributor II

Thx for publishing this, Appreciate your efforts

0 Likes
Not applicable
  • Thank you, this is a great job. It helps me a lot! Thanks for taking the time to do it.
0 Likes
retko1985
Creator II
Creator II

Hi.

I noticed that you sometime refer to a record as a field:

Transfer only some fields ( WHERE ) and some columns by naming them...

I think by using WHERE we are reducing records (rows), not fields. Correct me if I am wrong please.

Also in this sentence:

You may also, if you know the content of the QVD file, load only some columns by naming them or only some fields (WHERE clause studied later):

Thank you.

0 Likes
wiz_nerd
Creator
Creator

Hi Fabrice,

Explained very well. Appreciate your effort just going through it.

Thanks,

Arpit Vijay

https://www.linkedin.com/in/arpitv/

 

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2014-01-16 11:23 AM
Updated by: