append column
Posted: Wed Jan 19, 2005 3:13 pm
hi all,
i want to append a new column from a file which has only 1 row to another file which has three other columns. i do not have any common columns. but the output file should have all the rows of the second file populated with the same data of the only row in the first file.
for example:
**first file**
date
2004-01-19
**second file**
no code perm
1 A y
2 B n
3 C y
**output file**
date no code perm
2004-01-19 1 A y
2004-01-19 2 B n
2004-01-19 3 C y
i tried using a merge stage and a transformer, but did not get the required output.
can anyone suggest?
thanks.
i want to append a new column from a file which has only 1 row to another file which has three other columns. i do not have any common columns. but the output file should have all the rows of the second file populated with the same data of the only row in the first file.
for example:
**first file**
date
2004-01-19
**second file**
no code perm
1 A y
2 B n
3 C y
**output file**
date no code perm
2004-01-19 1 A y
2004-01-19 2 B n
2004-01-19 3 C y
i tried using a merge stage and a transformer, but did not get the required output.
can anyone suggest?
thanks.