topic Re: Joining between Tables in QlikView

Joining between Tables

hemachandran — Wed, 25 Nov 2020 16:16:04 GMT

Hi Everyone,

I am working in finance Application.

I have three tables

Vend Packing Slip Jour

Vend Packing slip Trans

Vend Trans

I want to join these three tables. I dont knew the linking table to join these tables..

Can anyone have idea for joining these tables.

thanks in Advance..

Re: Joining between Tables

marcus_malinow — Wed, 12 Apr 2017 13:16:40 GMT

Hi,

you'll need to provide a bit more information, such as a field list of each table, if you want a detailed answer.

Are these all different types of fact record? If so there are two common approaches - either concatenation of link tables. If you search you can find detailed descriptions of each of these approaches.

Marcus

Re: Joining between Tables

dathathreya — Wed, 12 Apr 2017 13:24:15 GMT

by using Left Join we can join three tables

Re: Joining between Tables

dathathreya — Wed, 12 Apr 2017 13:29:22 GMT

Plz go through this link .hope it will help u.

http://www.qlikfix.com/2011/02/07/merging-tables-the-join-prefix/

Re: Joining between Tables

hemachandran — Wed, 12 Apr 2017 14:11:06 GMT

Hi,

Thanks for ur response..

I am in need of technical terms of linking tables in database in finance Application..