topic Re: How to remove $sync key in QlikView

How to remove $sync key

Fri, 11 Oct 2013 05:22:27 GMT

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

Re: How to remove $sync key

Fri, 11 Oct 2013 05:28:22 GMT

U can create a following key field mean

Date & Ref No as Key

Re: How to remove $sync key

Fri, 11 Oct 2013 05:29:30 GMT

Hi All

Enclosed my QV doc.

Re: How to remove $sync key

manas_bn — Fri, 11 Oct 2013 05:46:15 GMT

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!

Re: How to remove $sync key

Fri, 11 Oct 2013 06:14:59 GMT

Qualify *;

Unqualify Date;

Table1:

Load blabla

Unqualify*;

do that for all the tables excep the linking table.

Re: Re: How to remove $sync key

senpradip007 — Fri, 11 Oct 2013 06:38:56 GMT

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]

Re: How to remove $sync key

saumyashah90 — Fri, 11 Oct 2013 07:12:02 GMT

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

Re: How to remove $sync key

Fri, 11 Oct 2013 15:00:30 GMT

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