Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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>
I am asking you related, What are you trying to achieve?
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
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
Rename fields which you getting synthetic keys
Or
Please share some QVD for at least 15-20 records
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>
Hi p M
Thank you for wanted to help me .
Enclosed my QVW.
Paul
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
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>