Problem with Column Import stage

shruthija · Post by **shruthija** » Tue Apr 21, 2009 7:54 am

Hi friends

I am running the column import stage, In the source file I loaded it with one type of filedefinition, and in the destination file it is loaded with the same filedefinition with two extra columns that are to be imported.

But when I run the job it is saying that, the extra added two columns were not found. The message was "Delimiter for <extra added column> were not found.

How to run it.
Please help me

Thanks in advance

dsuser_cai · Post by **dsuser_cai** » Tue Apr 21, 2009 11:32 am

the job log says it all. you need to Check for the delimiter. try to specify your own delimiter and test it. I use a Pipe symbol (|)

kduke · Post by **kduke** » Tue Apr 21, 2009 12:57 pm

You need to add the 2 columns in a transform.

ray.wurlod · Post by **ray.wurlod** » Tue Apr 21, 2009 1:29 pm

... or a Column Generator.

pandujoy · Post by **pandujoy** » Tue Apr 21, 2009 1:33 pm

add two more columns in the transformer

pandujoy · Post by **pandujoy** » Tue Apr 21, 2009 1:34 pm

add two more columns in the transformer