Discussion Board for collaboration on QlikView Scripting.
QlikView can pull the data from almost anything but what if your data looks like this?
Or you main data source is Oracle table but you need to validate it against Excel file
Very soon you will be able to perform powerful data transformation while loading the data into QlikView using Advanced ETL Processor QlikView connector.
Advanced ETL Processor has more than 300 data validation and transformation functions such as sorting grouping deduplications regular expressions and much more.
Process as follows:
Design data transformation using Advanced ETL Processor
Make sure that you have only one data writer and the connection type is QVX file
Than within QlikView write a script:
CUSTOM CONNECT TO "Provider=AETLP_QlikView_Connector.exe;XUserId=FXPZaHB;XPassword=POLVJLA;";
SQL SELECT *
Advanced ETL Processor QlikView connector is currently going through internal testing process and will be available in the next week. Please contract us if you wish to help us with testing.
ETL-Tools QlikView Connector is ready for the users
There are several several QlikView connectors available to the users. All they do is bring the data into QlikView but they do not do anything with the data
ETL-Tools QlikView Connector is the only one who can transform and validate the data while loading it QlikView
is it possible to extract data from sap bw and sap r/3 with the help of this tool ?.
not at the moment unless you have odc driver