Associating Column From 2 Excel Files

[Anonymous]

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.

[rachel_delany]

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.

[ahmar811]

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

[sasiparupudi1]

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]);

[Anonymous]

Thanks for the replies Interesting, seems I have a lot to learn (too much)