Inserting multiple columns with one line in the Column Transform Definition file

I want to insert two columns from one table into another, using an InnerJoin.  If I use two separate lines with Inner Joins, I get unwanted duplication of rows in the target table.  I believe I could create a calculated column that had a unique value for each row, insert it with the Inner Join and then insert the columns of interest with two Single Match Joins.  It would be easier if I could simply specify both columns of interest in a single line  with an InnerJoin as the join condition.

Thanks.

Login