Sunday, July 13, 2014

QV1 Inline Table

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

No comments:

Post a Comment

web stats