Create link table for sales and AR table

[#1]

Hi All

I wanted to remove my $syn key. my data model as below , when i try to create link table , i get stuck half way. as the script take very long to load.

LinkTable:

LOAD

[CUST_ID] & '|' & [company] as Link_Key1

Resident ARSummary;

Concatenate [LinkTable]:

LOAD Distinct

   [CUST_ID] & '|' & [company] as Link_Key2

Resident sales;

// script take long time to run.

//ARSummary2:

//NoConcatenate

//LOAD

//[CUST_ID] & '|' & [company] as Link_Key1,

//*

//Resident ARSummary;

[#2]

Hi All

Enclosed my QV Doc

[sushil353]

Hi,

Try to use autonumberhash128() instead of link table.

Please post some sample data or script for better resolution.

HTH

Sushil

[#4]

Hi Sushil

it is not due to autonumberhash . because i have same script from my previous link between inquiry and quotation table link. i am using the same approach.

My QV doc already posted after i post my question.

Paul