Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
krishnacbe
Partner - Specialist III
Partner - Specialist III

Join Load Statement and SQL Query

Hi

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

A

B

C

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

3 Replies
shree909
Partner - Specialist II
Partner - Specialist II

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.

krishnacbe
Partner - Specialist III
Partner - Specialist III
Author

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

shree909
Partner - Specialist II
Partner - Specialist II

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.