Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Cascade processing of QVD files.

Hello,

Let's say I have 2 views on database side ( Customer , Customer_LifeTime_Activity ) with following data :

Customer:

[c_id]

A

B

C

Customer_LifeTime_Activity:

[c_id], [value]

A 100

A 200

A 300

B 100

B 400

B 855

C 100

Extracts are generated from database views weekly. I use FastExport dump to file, and file import it's quicker then ODBC for Teradata. So in the end we have 2 calls of load utility :

LOAD

     @1 as c_id,

     @2 as value 

FROM

C:\Users\sg0216851\Desktop\Travelocity\04_QlickView\Dir_struct\Prod\data\in\tableA.txt

(txt, codepage is 1252, explicit labels, delimiter is \x7, msq);

which we will save into QVD files to get "Customer.qvd" and "Customer_LifeTime_Activity.qvd". Now I want to move some logic implemented

in Teradata side into QlikView, for example :

SELECT

c.C_id, Count(*)

FROM

Customer c  inner join Customer_LifeTime_Activity ca on c.c_id = ca.c_id

group by 1 ;

I now it's possible with QV, but it's not the point of discussion. I guess I need some back end process which will generate second level of  QVD

files based on QVD extracts calculation. How can I implement that for command line purpose ?  Second thing is error tracking, I want to return

log of QVDs processing into Teradata database via ODBC, is it possible with QV?   Third thing which I want is implementation of easy QV report to

manage jobs ( QVD processing  ). 😉

Thanks,

-R

0 Replies