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.