Where to set value for originalDbColumnName?

[CP1967]

Hi,

I am very(!) new to TALEND and I have the following question:

I started by importing an existing job, added via tMap a new out-column "EMAILDATA" and built the job.

In the

<name>.item

file I found the resulting following lines:

...

<column comment="" key="false" length="27" name="filepath" nullable="true" originalDbColumnName="VALUE_14" pattern="&quot;dd-MM-yyyy&quot;" precision="0" sourceType="VARCHAR2" type="id_String" usefulColumn="true"/>

<column comment="" key="false" length="-1" name="TO" nullable="true" originalDbColumnName="VALUE_15" pattern="" precision="-1" sourceType="" type="id_String" originalLength="-1" usefulColumn="true"/>

<column comment="" key="false" length="-1" name="EMAILDATA" nullable="true" pattern="" precision="-1" sourceType="" type="id_String" originalLength="-1" usefulColumn="true"/>

...

As you can see, the column "EMAILDATA" is missing the "originalDbColumnName" parameter. I would like to have it as "VALUE_16".

Where in Talend do I have to set this original DB column name?

Thanks in advance,

regards, Christine

[gjeremy1617088143 · Accepted solution]

Hi, your column is not comming from a database you add it on a tmap output, if your output is linked to tDBOutput just ensure that emailData is in the schema of the tDBOutput component.

Send me love and kudos

[CP1967]

Hi, thanks for your quick reply 🙂

EMAILDATA is in the schema of the output (see image below), but somewhere the values "VALUE_14" (for filepath) and "VALUE_15" must have been set (see code above: originalDbColumnName). This is what I do not find out.

[gjeremy1617088143]

Hi, are they coming from a tDBInput ?

[CP1967]

I found it. It's part of the output scheme of the insertRow component (tOracleOutput_1). You gave me the right hint, but I was looking in the wrong place at first.

Thank you very much 🙂