merge

pandu80 · Post by **pandu80** » Tue Jun 21, 2005 3:14 pm

Hi,

I am using the Merge stage.and i have set the 'pure inner join'.

Merge-------->Transformer---->seq_file.

when i run this job i got an error saying that 'FUNCTION get_next_output_row' failed.
[Input file : xyz.TXT] End of row termination characters expected.

where do i set these properties?.any help would be appreciated.

TIA

roy · Post by **roy** » Wed Jun 22, 2005 6:39 am

Hi,
usually it's in the output tab under the input files properties under first or second file format tab.
naturally the settings there must match to the actual ones of the file.
IHTH,

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Jun 22, 2005 7:34 am

Check whether there are more cols or chars in the file than mentioned in the properties.

elavenil · Post by **elavenil** » Wed Jun 22, 2005 9:55 am

Save the metadata of those input files and load the metadata while specifying the metadata and specify the delimeter etc as mentioned while those files created.

HTWH.

Regards
Saravanan

vinaymanchinila · Post by **vinaymanchinila** » Wed Jun 22, 2005 1:26 pm

Hi,
You should include all the columns from both the files in the output window even though they are same , and you can ignore them if you dont need once it is out of the stage, that way it doesnt give the error you are mentioning.
Good Luck

pandu80 · Post by **pandu80** » Thu Jun 23, 2005 2:24 pm

Hi,
Thanks for all for your input.But, still iam getting the error.
In the merge stage iam using pure inner join.If there is no key column matches merge stage raises error like " Function 'get_next_output_row' failed [Input file : xyz.TXT] End of row termination characters expected."

If key column matches it works fine.

what could be the reason?. any clues pls.

TIA.

pandu80 · Post by **pandu80** » Fri Jun 24, 2005 5:57 am

Hi,
can i use the merge stage, if there is no matching key column in input files?

TIA

ray.wurlod · Post by **ray.wurlod** » Fri Jun 24, 2005 12:20 pm