topic Re: Joins are not working except inner join in Management & Governance

Joins are not working except inner join

bvrg2747 — Mon, 09 Mar 2020 14:25:09 GMT

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.

Re: Joins are not working except inner join

dplr-rn — Mon, 09 Mar 2020 16:55:08 GMT

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

Re: Joins are not working except inner join

bvrg2747 — Tue, 10 Mar 2020 14:14:51 GMT

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

Re: Joins are not working except inner join

dplr-rn — Tue, 10 Mar 2020 14:46:37 GMT

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

Re: Joins are not working except inner join

bvrg2747 — Tue, 10 Mar 2020 14:54:09 GMT

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

Re: Joins are not working except inner join

squeakie_pig — Tue, 10 Mar 2020 16:49:32 GMT

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