topic Re: data extraction in QlikView

data extraction

vireshkolagimat — Tue, 28 Nov 2017 08:57:24 GMT

Hi All,

I have two tables namely Master and transaction table. What is the best way to extract date from these tables.

1. Write the sql query in SSMS and use the same sql query in Qlikview edit script to get the data OR

2. Extract individual table first and create the qvd file and join both the tables in the edit script?

Thank you.

Regards,

Viresh

Re: data extraction

avkeep01 — Tue, 28 Nov 2017 09:02:36 GMT

Hi Viresh,

Depeding on the performance of the SQL server u could use the SQL query, If it is slow, then use step 2. Because in step 2 you'll load the data twice.

Re: data extraction

YoussefBelloum — Tue, 28 Nov 2017 09:07:39 GMT

Hi,

I think this, is the best way to do it (a best practice),

have a look: Three Tier Architecture