Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Using Join to add a field

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);

Labels (2)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

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);

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

1 Reply
Highlighted
Partner
Partner

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);

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post