topic Re: Join Load Statement and SQL Query in QlikView

Join Load Statement and SQL Query

krishnacbe — Tue, 28 Aug 2012 14:04:29 GMT

I have a list of Job numbers in a QVD. I have to fetch data from a SQL table where the job number exist in QVD. I have to store the data from SQL query into a QVD no need to store data from QVD. Only for checking condition I need to use the QVD.

QVD Data

JobNo

SQL Data

JobNo	Values	Date
A	1	3/12/2012
B	2	4/12/2012
C	3	5/12/2012
D	4	6/12/2012

Please help me to write the script for fetching the related data (A,B & C) and store that in a QVD.

Thanks in advance

Regards

Krishna

Re: Join Load Statement and SQL Query

shree909 — Tue, 28 Aug 2012 14:12:02 GMT

Hi, try this

Temp:

load from qvd;

concatenate(Temp)

load from sqldata;

store temp into filename.qvd(qvd);

drop table temp;

so the new qvd will be created and stored in a filename which has all the rows from 2 taqbles

if you want only A,B, C then use inner join instead of concatenate.

Re: Join Load Statement and SQL Query

krishnacbe — Tue, 28 Aug 2012 14:30:32 GMT

Hi Shree

Thanks for your fast reply.

In my QVD i have huge data. If I concatenate the reloading time will be more. for example I have 3,376,538 records in QVD. if i use the example given above it will load 3,376,538 records but related data is only around 15,000.

Thanks

Regards

Krishna

Re: Join Load Statement and SQL Query

shree909 — Tue, 28 Aug 2012 14:34:17 GMT

i think that is only one time process use join function depening on ur requirement and create another qvd which has both tables.

but reloading from qvd will be fast.