Merge Stage Warning

[gaya3]

Hi,

I am trying to use the Merge stage for the first time and I am not seeing expected results.

My first input file:
1111,aaaa

My second input file:
1111,bbbb

and my ouput file is :
1111,1111,aaaa
,bbbb

whereas what I expected was
1111,1111,aaaa,bbbb

what could be going wrong?

I have set the properties as mentioned in the manual.
1) Mentioned the directory path of the input and output files in the General page
2) Mentioned the file names in the Ouput tab - General page
3) Join type is "Pure Inner Join"
4) First file and second file formats have default values
5) Given the column names and data types in First file columns and Second file columns
6) I have chosen the first field in both the files as mapping Keys
7) and selected all the four columns in the output

My design is
Merge Stage ---> Sequential File Stage

[Sainath.Srinivasan]

From the looks, it appears to be an issue with your record delimiter in file1.

What is the value set for the property ?

[gaya3]

It is comma for both the input files.

[Sainath.Srinivasan]

Set final delimiter to none and record delimiter to unix newline.

[gaya3]

Hi Sainath, after you put that question I just noticed that the line termination was Dos style. I changed it to Unix style and it works fine now.

Thanks!