Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to link ID columns to get names? Urgent help please

Hi,

I have UserID, TeamMember in table A. CEOID, TeamLeadID, CEOName, TeamLeadName in table B. I need to link UserID to both CEOID, TeamLeadID so that I have to show TeamMember as list box filter

UserID  TeamMember
1               XX
2               YY
454           ZZ
977           SS
123           UU
6               IO

CEOID, TeamLeadID, CEOName, TeamLeadName
1              454                  XX                  ZZ
2              123                  YY                  UU

Please can anyone suggest me how to link this.

Thanks.

4 Replies
Not applicable
Author

Please can anyone help me

Not applicable
Author

any help please as it is very urgent

sreenivas
Creator III
Creator III

PFA

buzzy996
Master II
Master II

try this,if ur looking for different data set as out put just cahnge the join typr inner to leif/right and see..

Tab1:

Load * Inline [

UserID,TeamMember

1,XX

2,YY

454,ZZ

977,SS

123,UU

6,IO

];

Tab2:

Inner Join Load * Inline [

CEOID,TeamLeadID,CEOName,TeamLeadName

1,454,XX,ZZ

2,123,YY,UU

];