Trying to create one pipeline for getting data from source to destination, using data flow transformation, using select statement. Here I struck we have a source column signal status map to sink side fit_crm_forecasrresolution and fit_crm_signalstatus.
I want source side 1 column with sink side 2 columns. How can I map, I want Singal status column records copy to sink side 2 columns. But I'm getting only 1 column in sink side.
The source columns in the select settings contains duplicate columns and to achieve your requirement, you need to disable the Skip duplicate input columns setting in that.
Now, it will allow duplicate input columns and gives expected output.