Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
chaitanyajami
Partner - Creator
Partner - Creator

DISPLAY FILED WITH ID IN INLINE LOAD

hi,

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

ID     NAME             DESIGN               MANAGER

1       MAHESH        CEO   

2       CHAITANYA  MANAGER                1             

3       NARENDRA  GM                            2

4       ESWAR         TECHL                      3

5       ASHOK          DEVLOPER               4

Labels (1)
1 Solution

Accepted Solutions
Peter_Cammaert
Partner - Champion III
Partner - Champion III

Add this after your INLINE LOAD

LEFT JOIN (AlreadyLoadedInlineTable)

  ID AS MANAGER,

  NAME AS MANAGERNAME

RESIDENT AlreadyLoadedInlineTable;

View solution in original post

4 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

Add this after your INLINE LOAD

LEFT JOIN (AlreadyLoadedInlineTable)

  ID AS MANAGER,

  NAME AS MANAGERNAME

RESIDENT AlreadyLoadedInlineTable;

Not applicable

Hi,

Can you please share your qvw file ?

HTH-KC

chaitanyajami
Partner - Creator
Partner - Creator
Author

hi,

Thanks its working fine.

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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.