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!