Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jorge_yanez
New Contributor

Associating Column From 2 Excel Files

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. 

EmployeeIDEmployee 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.

4 Replies
rachel_delany
Contributor

Re: Associating Column From 2 Excel Files

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
Contributor III

Re: Associating Column From 2 Excel Files

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
Honored Contributor III

Re: Associating Column From 2 Excel Files

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

Highlighted
jorge_yanez
New Contributor

Re: Associating Column From 2 Excel Files

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