Discussion board where members can get started with QlikView.
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)LOADSegment,colorFROM[C:\QLIKTEST\DataFile.xlsx](ooxml, embedded labels, table is Segments);
You need to include the field you are joining with in your Load. Like this:
sold_to, //the field that will join to the SOLD_TO tableSegment,colorFROM[C:\QLIKTEST\DataFile.xlsx](ooxml, embedded labels, table is Segments);
View solution in original post