Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
hemachandran
Partner
Partner

Joining between Tables

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..

4 Replies
marcus_malinow
Specialist III
Specialist III

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

dathathreya
Creator
Creator

by using Left Join we can join three tables

dathathreya
Creator
Creator

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

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

hemachandran
Partner
Partner
Author

Hi,

Thanks for ur response..

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