Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I am fairly new to Qlik and am just trying it out. Ive been watching some tutorials on Youtube but got stuck on the following.
I am working with two different Excel files.
File 1: Simple excel with 2 columns, one with employee ID and the other with a name.
EmployeeID | Employee Name |
---|---|
1111 | John Smith |
File 2: List of Sales, Product ID, but ONLY employee ID, no employee name.
How can associate these two variables so i can determine which employee sold the most?
Thank you in advance.
Hi Jorge,
If you make sure that your Employee ID field has the same name in both tables then Qlik should automatically link the 2 tables via that field. Then you can just bring in the fields as needed.
Hope that works for you.
Hi,
You right about field name must be same name and but in that value of both fields must be same then associate property will work.
Regards
Ahmar
Try
MAP_Name:
Mapping Load
EmployeeID,
Name
FROM
[File1.xlsx]
(ooxml, embedded labels, table is [Sheet1]);
Data:
LOAD
List of Sales,
Product ID,
EmployeeID,
Applymap('MAP_Name',EmployeeID,'NA') As Name
FROM
[File1.xlsx]
(ooxml, embedded labels, table is [Sheet1]);
Thanks for the replies Interesting, seems I have a lot to learn (too much)