topic Already create link key for 2 Table but two table not link ? in QlikView

Already create link key for 2 Table but two table not link ?

paulyeo11 — Thu, 06 Jul 2017 03:06:52 GMT

Hi All

autonumber( @1:9T & '_' & 'TDSS' ) as ARKey_,

I have create the above script at Payment_SG and AR_SG Tab

@10:38T as [COMPANY_PAY],

I have create the above script at Payment_SG tab

left(@10:38T,25) as [company_ap],

I have create the above script at AR_SG tab

Why these 2 table still not link ? can some one advise me where i go wrong ?

Paul

Re: Already create link key for 2 Table but two table not link ?

paulyeo11 — Thu, 06 Jul 2017 03:10:56 GMT

my QVW

Re: Already create link key for 2 Table but two table not link ?

Anil_Babu_Samineni — Thu, 06 Jul 2017 03:13:59 GMT

I don't have license to open your qvw. Here i think you are creating Link table and not give the same name to link..

Re: Already create link key for 2 Table but two table not link ?

paulyeo11 — Thu, 06 Jul 2017 03:20:27 GMT

Hi Anil

I have try to copy and paste

autonumber( @1:9T & '_' & 'TDSS' ) as ARKey_,

to both Tab , it still not work.

Paul

Re: Already create link key for 2 Table but two table not link ?

Anil_Babu_Samineni — Thu, 06 Jul 2017 03:22:25 GMT

When you say, It's not working. I would expect some clue whether any error or what? I am sorry, I don't have license to check if though i may offer you better on fly )

Re: Already create link key for 2 Table but two table not link ?

paulyeo11 — Thu, 06 Jul 2017 03:31:33 GMT

Hi Anil

See the below pic

Re: Already create link key for 2 Table but two table not link ?

Anil_Babu_Samineni — Thu, 06 Jul 2017 03:39:58 GMT

It's been Associate to Synthetic Keys and link also there. I would suggest in high prior related Synthetic key. Would you like to remove synthetic keys and check it may link to each other when we remove synthetic keys

Synthetic table\keys in QlikView – and how to avoid it | Tech Updates

Re: Already create link key for 2 Table but two table not link ?

paulyeo11 — Thu, 06 Jul 2017 03:54:21 GMT

Hi Anil

After i remove the below script from Payment_SG Tab , it work fine now.

left(@10:38T,15) as [company],

Can you share with me why this cause the issue ?

Paul Yeo

Re: Already create link key for 2 Table but two table not link ?

Anil_Babu_Samineni — Thu, 06 Jul 2017 03:57:52 GMT

Could be the reason, Seems you done twice and did multi tasking at a time

I have create the above script at Payment_SG and AR_SG Tab

@10:38T as [COMPANY_PAY],

I have create the above script at Payment_SG tab

left(@10:38T,25) as [company_ap],

This creates split from one field to 2 fields. May be here the debug we required

HTH

Anil

Re: Already create link key for 2 Table but two table not link ?

paulyeo11 — Thu, 06 Jul 2017 04:04:15 GMT

Hi Anil

What is correct approach ?

I know it should not using different name for company , which is very confuse .

It should be only one name.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

Re: Already create link key for 2 Table but two table not link ?

Anil_Babu_Samineni — Thu, 06 Jul 2017 04:06:17 GMT

Good Question, And don't confuse much. Can we expect your DM and business so then will think the way where you need to walk?

Re: Already create link key for 2 Table but two table not link ?

paulyeo11 — Thu, 06 Jul 2017 04:28:15 GMT

Hi Anil

I am not understanding .

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

Re: Already create link key for 2 Table but two table not link ?

Anil_Babu_Samineni — Thu, 06 Jul 2017 05:07:32 GMT

I am asking you related, What are you trying to achieve?

Re: Already create link key for 2 Table but two table not link ?

paulyeo11 — Thu, 06 Jul 2017 05:16:57 GMT

Hi Anil

I am try to achieve is :-

In ARSummary Table i have a field = TERMS.

I need TERMS Field link to AR Table.

Paul Yeo

Re: Already create link key for 2 Table but two table not link ?

Anil_Babu_Samineni — Thu, 06 Jul 2017 05:23:17 GMT

Seems, Still synthetic keys are there. If you want to continue with them. Then there must be other options if i see your code. If not, By help of common field you can link them. I would ask you to read related this? Will you?

Mapping Table and ApplyMap Function – QlikviewDiary

Re: Already create link key for 2 Table but two table not link ?

prma7799 — Thu, 06 Jul 2017 05:28:37 GMT

Rename fields which you getting synthetic keys

Please share some QVD for at least 15-20 records

Re: Already create link key for 2 Table but two table not link ?

paulyeo11 — Thu, 06 Jul 2017 05:30:03 GMT

Hi Anil

Thank you for share with me , it have a lot of useful info. It is very well organise. Which cover a lot of topic .

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

Re: Already create link key for 2 Table but two table not link ?

paulyeo11 — Thu, 06 Jul 2017 05:32:07 GMT

Hi p M

Thank you for wanted to help me .

Enclosed my QVW.

Paul

Re: Already create link key for 2 Table but two table not link ?

prma7799 — Thu, 06 Jul 2017 05:41:17 GMT

Hi Pual Sir,

Why you want to link TERM key with AR_TABLE and in AR_TABLE with which field you want link.

You can link Cust_id with cust_id_ar

Thanks

Re: Already create link key for 2 Table but two table not link ?

paulyeo11 — Thu, 06 Jul 2017 05:43:51 GMT

Hi PM

Because my AR Table does not have TERMS filed. That is the reasons .

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804