topic Re: Create link table for sales and AR table in QlikView

Create link table for sales and AR table

Wed, 23 Oct 2013 06:45:17 GMT

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;

Re: Create link table for sales and AR table

Wed, 23 Oct 2013 06:46:42 GMT

Hi All

Enclosed my QV Doc

Re: Create link table for sales and AR table

sushil353 — Wed, 23 Oct 2013 06:47:10 GMT

Hi,

Try to use autonumberhash128() instead of link table.

Please post some sample data or script for better resolution.

HTH

Sushil

Re: Create link table for sales and AR table

Wed, 23 Oct 2013 07:51:47 GMT

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