Concatenate the Data of Just the First Column of a Table in One Single Row

Scenario:

 Concatenate the Data of Just the First Column of a Table in One Single Row

Solution:

Step 1: pass Emp_Number to expression transformation.
Step 2: in expression transformation use variable port
var1 : var2
var2 : Emp_Number
var3 : IIF(ISNULL(var1),Emp_Number,var3||' '||Emp_Number)
Step 3: In outport port
out_Emp_Number : var3

Step 4: Pass this port through aggregator transformation. Don't do any
group by or aggregation.