Hi!
I'm new to Qlikview and looking for some answers regarding scripting. How can I create Qlickview joins that just join on a specific column (and not all that are having a matching name)? Let's say that I'm having the following tables:
Employee
Id | Person | DepartmentID | Flags
1000 , Bob , 2001 , 1000000
1001 , Sue , 2002 , 1100000
Department
Id | Name | Flags
2001 , HR , 01101111
2001 , R&D , 1100000
What is the best way of joining those tables on the DepartmentID <- ID field? The data is provided by SQL selects. I'm thinking of writing SQL views using unique names would be one idea, but there must be a simpler way. Please advice
Kind regards,
Karl