topic Join QVD Files in QlikView

Join QVD Files

Anonymous — Thu, 09 Apr 2015 18:36:46 GMT

Hello, I recently updated my app from using "Resident load" to QVDs. I need help Joining the QVDs and spitting out a txt file. See syntax below and hopefully we can go from there...

I have 2 qvds...

Store Network_Pivot INTO $(vPath_QVDs)Pivot.qvd(qvd);

Store High_Value_Networks INTO $(vPath_QVDs)High.qvd(qvd);

I would like to join the 2 qvds and store a text file then drop table and my syntax reads below...

Export_table:

Inner Join (Pivot)

Load *

//ID, Key, Address, Address2, City, State, Zip

From $(vPath_QVDs)High.qvd(qvd);

STORE Export_table into Q:\export_$(vDate).txt;

Drop Table Export_table

Re: Join QVD Files

maxgro — Thu, 09 Apr 2015 18:57:00 GMT

load * from a.qvd (qvd);

inner join (t)

load * from b.qvd (qvd);

store t .........

Re: Join QVD Files

Anonymous — Thu, 09 Apr 2015 19:14:20 GMT

Export_table:

load*

from

Export_table.qvd(qvd);

Inner Join (Export_table)

Load *

//ID, Key, Address, Address2, City, State, Zip

From $(vPath_QVDs)High.qvd(qvd);

STORE Export_table into Q:\export_$(vDate).txt;

Drop Table Export_table

Re: Join QVD Files

Anonymous — Thu, 09 Apr 2015 19:19:02 GMT

Pivot:

load

from

$(vPath_QVDs)Pivot.qvd(qvd);

Inner Join (Pivot)

Load

From

$(vPath_QVDs)High.qvd(qvd);

STORE Pivot into Q:\export_$(vDate).txt;

Drop Table Pivot

Re: Join QVD Files

Anonymous — Thu, 09 Apr 2015 19:27:48 GMT

I'm getting close Would you happen to know why my Store function stores my sql query and much more in with the tables under my txt file. I only want to see my columns. Ahh, maybe I need to remove * and add only column names? I'll give it a try, I'm so tired of reloading this app...

Re: Join QVD Files

Anonymous — Thu, 09 Apr 2015 19:39:24 GMT

Boo, that did not work. Store Function for my txt file is bringing back SQL query, bunch of other stuff along with my columns...