topic Re: DISPLAY FILED WITH ID IN INLINE LOAD in QlikView https://community.qlik.com/t5/QlikView/DISPLAY-FILED-WITH-ID-IN-INLINE-LOAD/m-p/945379#M325649 <HTML><HEAD></HEAD><BODY><P>Can you please close the discussion by marking an answer as "Correct"? That makes it easier for other community memebers to find solutions to similar problems. Thanks.</P></BODY></HTML> Mon, 21 Dec 2015 07:37:47 GMT Peter_Cammaert 2015-12-21T07:37:47Z DISPLAY FILED WITH ID IN INLINE LOAD https://community.qlik.com/t5/QlikView/DISPLAY-FILED-WITH-ID-IN-INLINE-LOAD/m-p/945375#M325645 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>i have loaded below table with inline load got the table view, but i want to display the manager name for each employee instead of manager id, please suggest how can i do that </P><P></P><P>ID&nbsp;&nbsp;&nbsp;&nbsp; NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DESIGN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MANAGER</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MAHESH&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CEO&nbsp;&nbsp;&nbsp; </P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CHAITANYA&nbsp; MANAGER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NARENDRA&nbsp; GM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ESWAR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TECHL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P>5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ASHOK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DEVLOPER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</P></BODY></HTML> Thu, 17 Dec 2015 09:12:32 GMT https://community.qlik.com/t5/QlikView/DISPLAY-FILED-WITH-ID-IN-INLINE-LOAD/m-p/945375#M325645 chaitanyajami 2015-12-17T09:12:32Z Re: DISPLAY FILED WITH ID IN INLINE LOAD https://community.qlik.com/t5/QlikView/DISPLAY-FILED-WITH-ID-IN-INLINE-LOAD/m-p/945376#M325646 <HTML><HEAD></HEAD><BODY><P>Add this after your INLINE LOAD</P><P></P><P><SPAN style="font-family: 'courier new', courier;">LEFT JOIN (AlreadyLoadedInlineTable)</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp; ID AS MANAGER,</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp; NAME AS MANAGERNAME</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">RESIDENT AlreadyLoadedInlineTable;</SPAN></P></BODY></HTML> Thu, 17 Dec 2015 13:27:31 GMT https://community.qlik.com/t5/QlikView/DISPLAY-FILED-WITH-ID-IN-INLINE-LOAD/m-p/945376#M325646 Peter_Cammaert 2015-12-17T13:27:31Z Re: DISPLAY FILED WITH ID IN INLINE LOAD https://community.qlik.com/t5/QlikView/DISPLAY-FILED-WITH-ID-IN-INLINE-LOAD/m-p/945377#M325647 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can you please share your qvw file ?</P><P></P><P>HTH-KC</P></BODY></HTML> Thu, 17 Dec 2015 13:32:16 GMT https://community.qlik.com/t5/QlikView/DISPLAY-FILED-WITH-ID-IN-INLINE-LOAD/m-p/945377#M325647 2015-12-17T13:32:16Z Re: DISPLAY FILED WITH ID IN INLINE LOAD https://community.qlik.com/t5/QlikView/DISPLAY-FILED-WITH-ID-IN-INLINE-LOAD/m-p/945378#M325648 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>Thanks its working fine.</P></BODY></HTML> Sat, 19 Dec 2015 17:33:14 GMT https://community.qlik.com/t5/QlikView/DISPLAY-FILED-WITH-ID-IN-INLINE-LOAD/m-p/945378#M325648 chaitanyajami 2015-12-19T17:33:14Z Re: DISPLAY FILED WITH ID IN INLINE LOAD https://community.qlik.com/t5/QlikView/DISPLAY-FILED-WITH-ID-IN-INLINE-LOAD/m-p/945379#M325649 <HTML><HEAD></HEAD><BODY><P>Can you please close the discussion by marking an answer as "Correct"? That makes it easier for other community memebers to find solutions to similar problems. Thanks.</P></BODY></HTML> Mon, 21 Dec 2015 07:37:47 GMT https://community.qlik.com/t5/QlikView/DISPLAY-FILED-WITH-ID-IN-INLINE-LOAD/m-p/945379#M325649 Peter_Cammaert 2015-12-21T07:37:47Z