Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Join is not working

Hi,

i have just imported two tables which i would like to join. i would like to do it not with sql. can someone help me ?

4 Replies
oknotsen
Master III
Master III

Join ‒ Qlik Sense

In order for join to work, field names will have to be 100% the same.

"Applejuice" and "Applejuice" will work.

"Applejuice" and "Sweet.Applejuice" will not work.

May you live in interesting times!
Anonymous
Not applicable
Author

ok in general i got the point ... but why i can join fields which are not 100% the same like u see below. I can really join on each filed excluded the field i need.

in this picture the join would work ...

in this picture the join will not work

and sorry i really don't know why the join in the second picture will not work (btw. this is the join i need)

Thanks for help

oknotsen
Master III
Master III

You will have to show me the script for me to be able to tell you why something does or does not work.

May you live in interesting times!
agigliotti
Partner - Champion
Partner - Champion

let's try to do the join manually in the script instead of using data load wizard.