Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sales Force and table JOIN Problem

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

modelS/NRev Type
A1Tyre
B2Oil
C3Other

Table 2: from excel file

ModelS/Ndate
A110/10/2015
B222/10/2015
C330/10/2015

Table 3: Result

ModelS/NRev Typedate
A1Tyre
B2Oil
C3Other
A?10/10/2015
B?22/10/2015
C?30/10/2015

Does anyone had the same problem?


Thanks!

0 Replies