topic How to link up information from two excel docs in QlikView https://community.qlik.com/t5/QlikView/How-to-link-up-information-from-two-excel-docs/m-p/761924#M1042415 <HTML><HEAD></HEAD><BODY><P>I have employee ID in 1 excel spreadsheet, along with other bits of informaiton about machinery</P><P>and another spreadsheet with the names for corresponding employee ID's</P><P></P><P>I'm trying to create a pivot table which uses employees names correlated to information about machinery, rather than using employer ID. </P></BODY></HTML> Wed, 03 Dec 2014 00:42:37 GMT 2014-12-03T00:42:37Z How to link up information from two excel docs https://community.qlik.com/t5/QlikView/How-to-link-up-information-from-two-excel-docs/m-p/761924#M1042415 <HTML><HEAD></HEAD><BODY><P>I have employee ID in 1 excel spreadsheet, along with other bits of informaiton about machinery</P><P>and another spreadsheet with the names for corresponding employee ID's</P><P></P><P>I'm trying to create a pivot table which uses employees names correlated to information about machinery, rather than using employer ID. </P></BODY></HTML> Wed, 03 Dec 2014 00:42:37 GMT https://community.qlik.com/t5/QlikView/How-to-link-up-information-from-two-excel-docs/m-p/761924#M1042415 2014-12-03T00:42:37Z Re: How to link up information from two excel docs https://community.qlik.com/t5/QlikView/How-to-link-up-information-from-two-excel-docs/m-p/761925#M1042416 <HTML><HEAD></HEAD><BODY><P>When loading both tables, ensure that the Employee ID field is written in exact the same way in both tables - you can rename the fields like e.g. </P><P>File1:</P><P>LOAD</P><P>[employee ID] as EmployeeID,</P><P>...</P><P>from...file1</P><P></P><P>File2:</P><P>LOAD</P><P>EmpID as EmployeeID,</P><P>...</P><P>from ....file2</P></BODY></HTML> Wed, 03 Dec 2014 00:46:16 GMT https://community.qlik.com/t5/QlikView/How-to-link-up-information-from-two-excel-docs/m-p/761925#M1042416 danieloberbilli 2014-12-03T00:46:16Z Re: How to link up information from two excel docs https://community.qlik.com/t5/QlikView/How-to-link-up-information-from-two-excel-docs/m-p/761926#M1042417 <HTML><HEAD></HEAD><BODY><P>Please provide sample data..</P></BODY></HTML> Wed, 03 Dec 2014 02:21:42 GMT https://community.qlik.com/t5/QlikView/How-to-link-up-information-from-two-excel-docs/m-p/761926#M1042417 2014-12-03T02:21:42Z