Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

ch_riadh
Not applicable

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
msheraton
Not applicable

Re: join table

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

Re: join table

Hi!

You only need a Join! Following example.