Discussion board where members can learn more about Qlik Sense App Development and Usage.
Hello! How i can decode Last Name from field 'Reports to' if used 'EmpID'?
Could you show an expected example?
For value 4 from 'Reports To' I show for Last Name - Callins
Question is not clear? What is the outcome
You can try using Mapping. See below...
load * inline [
EmpID, LastName, ReportsTo,
ApplyMap('MapLastName',ReportsTo,Null()) as ReportsToLastName
Drop table Table;