Jump to content
We've recently updated our Privacy Statement, available here. ×

How do I separate out one row into separate rows


Christopher Anderson

Recommended Posts

I have two tables to join. One table has company information and the other has employee information. While I can join them on EIN, I also need to be able to identify the employees by a secondary identifier. That identifier is in the company information row, but is one of three columns with similar information (which are unique identifiers for plan options). If I use the column for the employee identifier for one of those columns, then I can't match it again to the second or third columns. How can I get that row from the employer table separated out so that I only have one plan option per employer row (multiple employer rows are fine).
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...