How to remove $sync key

[#1]

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);

[#2]

U can create a following key field mean

Date & Ref No as Key

[#3]

Hi All

Enclosed my QV doc.

[manas_bn]

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!

[#5]

Qualify *;

Unqualify Date;

Table1:

Load blabla

Unqualify*;

do that for all the tables excep the linking table.

[senpradip007]

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]

[saumyashah90]

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

[#8]

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