We can load data into qlikview by various ways such as
- Load data from different type of DataSource (RDBMS or Nosql db),
- Load Data from Flat file,
- Load Data from SAP interface.
Another type of loading is we can directly type the table script in script window.
Syntax
Open script window with the help of ctrl+e or click on icon.
[counting]:
LOAD * INLINE [
ID, Description
1, One
2, Two
3, Three
4, Four
5, Five
6, Six
7, Seven
8, Eight
9, Nine
10, Ten
];
Now counting table have two columns id and description
- Load data from different type of DataSource (RDBMS or Nosql db),
- Load Data from Flat file,
- Load Data from SAP interface.
Another type of loading is we can directly type the table script in script window.
Syntax
Open script window with the help of ctrl+e or click on icon.
[counting]:
LOAD * INLINE [
ID, Description
1, One
2, Two
3, Three
4, Four
5, Five
6, Six
7, Seven
8, Eight
9, Nine
10, Ten
];
Now counting table have two columns id and description
No comments:
Post a Comment