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

[paulyeo11]

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

[Anil_Babu_Samineni]

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?

[paulyeo11]

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>

[Anil_Babu_Samineni]

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

[paulyeo11]

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

[Anil_Babu_Samineni]

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

[prma7799]

Rename fields which you getting synthetic keys

Or

Please share some QVD for at least 15-20 records

[paulyeo11]

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>

[paulyeo11]

Hi p M

Thank you for wanted to help me .

Enclosed my QVW.

Paul

[prma7799]

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

[paulyeo11]

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

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