Forum Discussion
Instert Row based on Condition
I have two tables that are tied by COID. I have a list of Vacant posistions per COID and i need to add this row to the table that has the employees. Table 1 Vacant Posistion: Vacant COID...
parry2k the second table below and highlighted green is what i need to add into table 1
| Division | COID | Facility | Employee Name | Job Description | Yearly Pay | |||||
| SC DIVISION | 12345 | Harbor Town | Tom Thomas | Supv Fac Mgmt/Safety/Sec | $57,138 | |||||
| SC DIVISION | 12345 | Harbor Town | Brad Sellers | Coordinator Support Svcs (CW) | $52,000 | |||||
| SC DIVISION | 12345 | Harbor Town | Morgan Evans | Engineering Craft Worker | $44,554 | |||||
| SC DIVISION | 12345 | Harbor Town | Sam Smith | Engineering Tech Specialist | $44,138 | |||||
| SC DIVISION | 12345 | Harbor Town | Vacant | Dir Fac Mgmt/Safety/Sec | xxxxxx | |||||
| Vacant | COID | Facility | Change | Vacancy Date | DFM Start Date | |||||
| Vacant | 12345 | Harbor Town | Left HCA | 6/14/2019 | 12/20/18 | |||||
| Vacant | 54635 | Tri County | Left HCA | 4/9/2018 | 9/17/18 | |||||
| Vacant | 22448 | Macon | Left HCA | 4/20/2020 | 7/2/18 | |||||
| Vacant | 34854 | Table Top | Left HCA | 3/20/2020 |
parry2k
Super User
Super UserAnonymous how the table 1 columns are mapped to table 2, you can use UNION DAX function or you can append queries in Power Query
parry2k they are mapped using COID. I feel that i am going to need to do a Power Query but not sure the best way to go about it.
- edhans
Community Champion
What is COID? To add records from one table to another, use Table.Combine(), which is the APPEND menu item on the Home ribbon.
Otherwise, I'll need a few more specifics about the goal and what you are using.
edhans I am trying to add a rows to the employee table when there is a vacanies in table 2.
COID is what they both are tied to.
