topic Re: Where to set value for originalDbColumnName? in Talend Studio

Where to set value for originalDbColumnName?

CP1967 — Fri, 15 Nov 2024 23:19:58 GMT

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:

...

...

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

Re: Where to set value for originalDbColumnName?

gjeremy1617088143 — Fri, 07 Jan 2022 15:23:15 GMT

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

Re: Where to set value for originalDbColumnName?

CP1967 — Mon, 10 Jan 2022 08:12:00 GMT

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.

Re: Where to set value for originalDbColumnName?

gjeremy1617088143 — Mon, 10 Jan 2022 08:17:36 GMT

Hi, are they coming from a tDBInput ?

Re: Where to set value for originalDbColumnName?

CP1967 — Mon, 10 Jan 2022 09:12:58 GMT

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 🙂