How do I separate out one row into separate rows

[Christopher Anderson]

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).

[Khushboo Rabadia]

To match again, you can use "Calculate new column" transformation referencing EIN column which would create imported column instead of calculated column and hence you will be able to join it for second and 3rd column