Join QVD Files

[Anonymous]

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

[maxgro]

t:

load * from a.qvd (qvd);

inner join (t)

load * from b.qvd (qvd);

store t .........

[Anonymous · Accepted solution]

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

[Anonymous]

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

[Anonymous]

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...

[Anonymous]

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