Populate all rows in a single column
Posted: Sun Apr 28, 2013 9:11 pm
Hi All,
I have a requirement in which I have to read all the source rows (only one column in each row) and load them into a single column in target. The no of rows is not fixed.
Example:
Input Data:
A
B
C
D
E
F
G
Output Data:
ABCDEF
Any idea how we can do this. I have done the pivot but it is populating the records into different columns where as i want it to be single column.
Thanks
I have a requirement in which I have to read all the source rows (only one column in each row) and load them into a single column in target. The no of rows is not fixed.
Example:
Input Data:
A
B
C
D
E
F
G
Output Data:
ABCDEF
Any idea how we can do this. I have done the pivot but it is populating the records into different columns where as i want it to be single column.
Thanks