Using Join to add a field

[tomdabek]

I am struggling to add fields to an existing table using an excel file.

There is a table SOLD_TO (with a field also called sold_to) already in the Qlikview qvw file

I have a excel file with a list of most but not all sold_to instances as well as additional information segment and color.

Any time i try a join, every possibility of segment and color is assigned to every existing sold_to

It is as if Qlikview cannot find the fields to join on.

(the first column in the excel file is sold_to and corresponds to the sold_to field in the table SOLD_TO)

Inner JOIN(SOLD_TO)
LOAD
Segment,
color

FROM
[C:\QLIKTEST\DataFile.xlsx]
(ooxml, embedded labels, table is Segments);

[Vegar · Accepted solution]

You need to include the field you are joining with in your Load. Like this:

Inner JOIN(SOLD_TO)
LOAD

sold_to, //the field that will join to the SOLD_TO table
Segment,
color

FROM
[C:\QLIKTEST\DataFile.xlsx]
(ooxml, embedded labels, table is Segments);