Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have trouble joining two different tables. Have searched through community for answers with no results. I do believe that i am missing something.
If i am trying to join some data just inline in script it works perfectly:
TEST:
Load * Inline [
ID,NAME1,SURNAME1,REGION,COUNTRY,NUMBER,T1
1,a,aa,EU,UK,323,T1
2,b,bb,EU,UK,454,T1
];
Join(TEST)
LOAD * Inline [
ID,NAME2,SURNAME2,REGION,COUNTRY,NUMBER,T2
1,a,aa,EU,UK,323,T2
2,b,bb,EU,UK,454,T2
And i am getting result which i do want to get:
I do want to create a table with unique combinations from those 2 tables and it works perfectly with Inline.
However, i am loading data from xlsx and the result is not what i have expected
Here is a simple script that i have:
TABLE:
LOAD
ID, //can repeat
NAME1,
SURNAME1,
REGION,
COUNTRY,
NUMBER,
'T1' as T1 //field for checking if joined correctly
FROM xlsx file
Join(TABLE)
NAME2,
SURNAME2,
'T2' as T2 //field for checking if joined correctly
FROM other xlsx file
There is no unique IDs in both tables from xlsx.
There are some lines that matches in both xlsx's.
I ma just trying to find some hidden hint which i have missed.
Help is very appreciated.
With my skills in Qlikview, QUALIFY does not help solve the issue.
I would really appreciate if somebody can help with this.
I have an idea that Join is not working if there is several lines that are matching.
Consider using ApplyMap rather than joining the data. Mapping will avoid the risk of duplicating the measures in your data.
See this post for more details Don't join - use Applymap instead
what is the expected output for the above problematic data?
