Find Employees Manager Manager
Good Afternoon,
I have a dataset that has EE#, lastname, firstname, Manager, ManagerEE#, ect…, and my question is I need to find the employees Manager- Mananger; all of the employees are listed but there is no column for Manager's Manager.
How can I do that in an ETL to create a new column. Here is an example of how I want the data to look:
Thank you
0
Best Answer
-
You can join the dataset to itself so that the employee's manager field is joined to the employee field then you can rename the second manager field to manager of manager.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Answers
-
You can join the dataset to itself so that the employee's manager field is joined to the employee field then you can rename the second manager field to manager of manager.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 308 Workbench
- 7 Cloud Amplifier
- 10 Federated
- 3.8K Transform
- 661 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 819 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 781 Automate
- 193 Apps
- 483 APIs & Domo Developer
- 84 Workflows
- 23 Code Engine
- 43 AI and Machine Learning
- 22 AI Chat
- 3 AI Projects and Models
- 18 Jupyter Workspaces
- 409 Distribute
- 116 Domo Everywhere
- 282 Scheduled Reports
- 11 Software Integrations
- 146 Manage
- 142 Governance & Security
- 8 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive