Sales Force and table JOIN Problem

Anonymous — Fri, 20 Nov 2020 18:02:30 GMT

Hi!

I did a Qlikview application, loading all datas from excel files, doing joins, crosstables and so on. But now, loading the first table from Sales Force (SF) I get an error while joining. Type of join is simple, only join itself. The error I am getting is that is not merging the rows. It simply concatenate lines from both tables and the field which is supposed to be the key for joining is replaced by '?' in the second table, only in it.

See an example:

Table 1: from sales force

model	S/N	Rev Type
A	1	Tyre
B	2	Oil
C	3	Other

Table 2: from excel file

Model	S/N	date
A	1	10/10/2015
B	2	22/10/2015
C	3	30/10/2015

Table 3: Result

Model	S/N	Rev Type	date
A	1	Tyre
B	2	Oil
C	3	Other
A	?		10/10/2015
B	?		22/10/2015
C	?		30/10/2015

Does anyone had the same problem?

Thanks!

topic Sales Force and table JOIN Problem in QlikView

Sales Force and table JOIN Problem