Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi MBA
I have follow your instruction.
Now may i ask you how to remove the $sync 3 table from my data structure ?
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.
Hi Sir
since rename the date field , Now only issue is how to make the calendar island link to quotation and inquiry. any idea ?
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
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);
Hi sir
I for get to mentioned that , Once i add Date field at link table , i will get syn key table.
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
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;
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
Hi Paul,
Just try with below app.