Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today

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
Partner
Partner

Simply excellent, very useful. Thx

0 Likes
Not applicable

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

0 Likes
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
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
Contributor III
Contributor III

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: