Vlookup using calculated field in Tableau

user_15648808 0
Viewed 127

I am new to the Tableau can anyone help me with the below example I have employees details from agent till managing director in in data Set Column A contains emp_id and column B contains Name of the Employees name and column C contains the supervisors emp_id.

I want supervisor name in column D which is already available in column B. It's like using vlookup in excel

=vlookup (c1,A:B,2,0)

How can use the same logic in tableau

calculated-field vlookup tableau-api calculated-columns
1 Answers

Let's assume your data is like

enter image description here

create a join with itself in tableau something like this

enter image description here

After this you can you may each empoyee's superviosr name

enter image description here

user_28848590
Related