Joins are not working except inner join

[bvrg2747]

I am new to qliksense.

Script:

T3:
LOAD
"Employee Code",
Manager
FROM [lib://DataFiles/Tableau-DIY-BDCS.xlsx]
(ooxml, embedded labels, table is Sheet3);

Inner Join

T4:
LOAD
"Employee Code",
"Employee Name"
FROM [lib://DataFiles/Tableau-DIY-BDCS.xlsx]
(ooxml, embedded labels, table is Sheet4);

i have used same script for inner join, outer join, left join, right join. But only inner given proper output and remain all joins are showing like attached screen shot.I tried like below also.

Script:

T3:
LOAD
"Employee Code",
Manager
FROM [lib://DataFiles/Tableau-DIY-BDCS.xlsx]
(ooxml, embedded labels, table is Sheet3);

Inner Join(T3)

T4:
LOAD
"Employee Code",
"Employee Name"
FROM [lib://DataFiles/Tableau-DIY-BDCS.xlsx]
(ooxml, embedded labels, table is Sheet4);

Only inner join with same scripts , other joins not workings. Please suggest me.

[dplr-rn]

share a sample of the 2 excels and i can try and help

[bvrg2747]

Sheet 1:

Employee Code	Manager
E1	Manager 1
E3	Manager 1
E5	Manager 2

Sheet 2:

Employee Code	Employee Name
E1	Sachin Tendulkar
E2	Rahul Dravid
E4	Mohsin Khan

[dplr-rn]

With your sample data all joins work correctly. results are below.

can you share the output of the inner join you are getting?

left join 

T3:
load * inline [
Employee Code, Manager
E1, Manager 1
E3, Manager 1
E5, Manager 2
];
left join (T3)
load * inline [
Employee Code, Employee Name
E1, Sachin Tendulkar
E2, Rahul Dravid
E4, Mohsin Khan

];

right join

script same as above apart from right join (T3)

inner join

[bvrg2747]

inner join output same as your output. only issue with other joins.

except inner join all other joins are getting null values. i will try with your script, will see.

Thank you

[squeakie_pig]

Does "Employee Code" in your spreadsheet have any trailing blanks?  Can use rtrim("Employee Code") to check this.