Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
t:
load * from a.qvd (qvd);
inner join (t)
load * from b.qvd (qvd);
store t .........
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
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
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...
Boo, that did not work. Store Function for my txt file is bringing back SQL query, bunch of other stuff along with my columns...