My link table have $syn key

[#1]

Hi All

I have a data model , which i already created the link table key. but i don't know how to remove the syn key.

[#2]

Hi MBA

I have follow your instruction.

Now may i ask you how to remove the $sync 3 table from my data structure ?

[bbi_mba_76]

In the Inquiry and quotation tables there is again the Date field, this is generating the sync table, try to rename them in Q.Date and I.Date as last action in your script.

[#4]

Hi Sir

since rename the date  field , Now only issue is how to make the calendar island link to quotation and inquiry. any idea ?

[SunilChauhan]

Hi paul,

why not you make link table where you have Date ,Key_I,Key_Q

and Enquiry has Key_I and rename date and rename field which create syn key

and question table has Key_Q and rename date field and rename fields which create syn key

and on this date link master calender to Linktable.

see the attached image

hope this helps

SUNIL

[#6]

Hi Sir

After i rename the date field , now my issue is i get loop , this is because in my link table i am not able to add Date filed,

LinkTable:

load Date&[Ref. No_I] as Key_I from $(vQVDPath1)Inquiry.qvd (qvd);

concatenate (LinkTable)

load Date&[Ref. No] as Key_I, Key_Q from $(vQVDPath1)Quotation.qvd (qvd);

[#7]

Hi sir

I for get to mentioned that , Once i add Date field at link table , i will get syn key table.

[SunilChauhan]

Hi paul

you are doing correct .only thing need to do is add date field to Linked table and rename date field in both question and inquiry.

i mean in question

date as Q.Date and

in inquiry

Date as I.Date

modify linked table as

Linked:

Load

Key_I

Date

from Inquiry;

concatenate(Linked)

Load

Key_Q

Date

from question

hope this will help

Sunil

[Anonymous]

Paul,

Can you add below code to your appa and see hope it will work.

Drop 

Table

LinkTable;

LinkTable:
LOAD

Date

& '|' & [Ref. No_]

& '|' & [Key_I]

as

Link_Key1

,
Date

as

Date

Resident

Inquiry1;

Concatenate

[LinkTable]:
LOAD

Distinct

Date

as

Date

,
Date

& '|' & [Ref. No]

& '|' & [Key_Q]

as

Link_Key2

Resident

Quotation;

Inquiry2:
LOAD

*,
Date

& '|' & [Ref. No]

& '|' & [Key_Q]

as

Link_Key2

Resident

Inquiry1;

Drop

Fields

Date

, [Ref. No]

, [Key_Q]

from

Inquiry2;

RENAME

Table

Inquiry2 to

Inquiry1;

Quotation1:
LOAD

*,
Date

& '|' & [Ref. No]

& '|' & [Key_Q]

as

Link_Key2

Resident

Quotation;

Drop

Fields

Date

, [Ref. No_]

, [Key_I]

from

Quotation1;

RENAME

Table

Quotation1 to

Quotation;

Drop

Tables

Quotation1, Inquiry2;

[#10]

Hi Sunil

I think i have to live with the $syn key table , most impt the table is still working fine. just that it look not so nice. Thank you very much.

Paul

[Anonymous]

Hi Paul,

Just try with below app.