Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
ch_riadh
Partner - Creator II
Partner - Creator II

join table

hi gays ,

i have 2 fiels
table1 name = DW

table2 name = BUDGET

Field1 name : DW.day

Field2 name : BUDGET.day

in the first field i have for exemple : A B and C

in the second field i have for exemple : A B and D

I want a third field with : A,  B, C and D.


So i think thant is with OUTER JOIN.

so How can i do it ???

syntax plz.

thanks

2 Replies
RedSky001
Partner - Creator III
Partner - Creator III

DW:

load * Inline [Day

A

B

C

];

JOIN (DW)

load * Inline [Day

A

B

C

D

];

Your question is not very clear, however you should get away with using just "JOIN" this is a natural join.

From the QV Reference manual p918:

An operation that uses two tables and combines them into one. The records of the table

produced are combinations of records in the two original tables, usually such that the

two records contributing to any given combination in the produced table have a common value for one or several common fields, a so called natural join. In QlikView, joins

can be made in the script, producing logical tables. Inner join, Left join, Right join and

Outer join are all possible operations.

Not applicable

Hi!

You only need a Join! Following example.