Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have 2 table when i link them up , i want to remove the sync key it is possible ? what i mean is
create link table having 2 field Date and Ref .No so that it look good.
load * from $(vQVDPath1)Inquiry.qvd (qvd);
load * from $(vQVDPath1)Quotation.qvd (qvd);
U can create a following key field mean
Date & Ref No as Key
Hi All
Enclosed my QV doc.
Paul,
You can use the below code as a reference:
Table1:
load //All fields except Date and RefNo, Date&RefNo as Key1 from qvd1;
load //All fields except Date and RefNo, Date&RefNo as Key2 from qvd2;
LinkTable:
load Date&RefNo as Key1, Date, RefNo from qvd1;
concatenate(LinkTable)
load Date&RefNo as Key2,Date, RefNo from qvd2;
//Create Calendar Table with Date field
Cheers!
Qualify *;
Unqualify Date;
Table1:
Load blabla
Unqualify*;
do that for all the tables excep the linking table.
Hi Paul,
Try this:
load
Date,
[Ref. No] As Inquiry_RefNo
from
Inquiry.qvd (qvd);
load
Date,
Q.Customer,
Q.No,
Q.BRAND,
[Ref. No] As Quotation_RefNo
from
Quotation.qvd (qvd);
Type all of your Fields in two tables apart from [Ref. No]
Hey Paul,
You are loading Date and RefNo in both Inquiry and Quotation.
What you can do is dont reload RefNo from inquiry or Quotation(from any one)
And then reload it
Hi All
Many thank for all your input. Today just unable to focus , all the feedback i think should work fine, will try again some other day.
Paul