Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ETL ( QlikView)

Hi QlikView Experts,

I am new in QlikView I am trying to be familiar with this product I heared that QlikView is having ETL thing i

is it ?  can anyone explain me how ..

Regards

Bhuwan

1 Solution

Accepted Solutions
Not applicable
Author

10 Replies
its_anandrjs

You can do the ETL with the qlikview application and refer this manuals

ETL-Tools_QlikView_Connector_User_Manual.pdf

ETL-Tools QlikView Connector

And refer this also

ETL details and  Overview

whiteline
Master II
Master II

Hi.

Read the QlikView reference manual.

sujeetsingh
Master III
Master III

ETL Concepts as:

---Option to load data as temp tables

---functions to implement your logic

---One can implement Data ware house concepts as Star schema

--

--

--

A lot more so just follow Reference manual.

its_anandrjs

You can do ETL from your own way like

Extract

1. Read the raw data in the qlikview application.

Transform

2. Read the raw data and transform the field in a meaning full way using various functions and apply to tables.

Load

3. Read the transform data and loading the data according to business logic or create a data ware housing concepts.

jagan
Luminary Alumni
Luminary Alumni

Hi Bhuwan,

You can transform the data like Other ETL tools do using Qlikview Scripting.  If you want you can also Expressor tool for Qlikview ETL also.

You can use normal SQL queries to load the data into Qlikview, and if you are using any Flat files then you have to use LOAD statement of Qlikview.

In Qlikview there are many in built transformations available like CrossTable(for unpivoting), IntervalMatch, Mapping Load for Lookup, Generic load, Joins like LEFT, RIGHT and INNER, etc.

Refer Qlikview Reference manual or you buy Qlikview 11 for Developers, in this books you can find more details.

Hope this helps you.

Regards,

Jagan.

Not applicable
Author

Thank You I will read it.

Not applicable
Author

Thank You I will read it.

Not applicable
Author

Thank You Jagan.

Not applicable
Author

Thank You Guys ..for your valuable informations.