topic Re: Regarding Column name with space load from DB to file in Talend Studio

Regarding Column name with space load from DB to file

BA621858188 — Sun, 05 Jun 2022 17:30:43 GMT

Hi All,

I wanted to know the resolution. I have database as source where my column name is employee_id but in my target I want column name as employee id (Space).

Could you please help

Re: Regarding Column name with space load from DB to file

Anonymous — Mon, 06 Jun 2022 02:40:54 GMT

If you want to output the column name in the target file, use a tFixedFlowInput to define the column names and write them to the file in the first subjob. In next subjob, append the data to the same file.

Regards

Shong

Re: Regarding Column name with space load from DB to file

BA621858188 — Mon, 06 Jun 2022 15:01:18 GMT

Could you give more details with rough job design. My source is sql database and target is file. and In the target file before header I want current date.

Target file Output

currentdate

column headers

data of file

Re: Regarding Column name with space load from DB to file

Anonymous — Tue, 07 Jun 2022 02:59:07 GMT

@Vrushabh Malbari, because talend does not allow you to contain space in the column name, so use a tfixedFlowInput to write only one row (all column names) to the file in the first subjob.

tFixedFlowInput--main--tFIleOutputDelimited1

|onsubjobok

tMssqlInput--main-tFileOutputDelimited2

tFileOutputDelimited2: append the data to the same file, uncheck the 'include headers' box.

Hope it is helpful.

Regards

Shong

Re: Regarding Column name with space load from DB to file

BA621858188 — Tue, 07 Jun 2022 17:14:50 GMT

Its working now for Headers. But I have one more requirement to include current_date before headers. So for that, Do I need to add one more tfixedflowinput subjob?

Also do you have any job design for incremental load ( source is DB and target is file)

Thank you

Re: Regarding Column name with space load from DB to file

Anonymous — Wed, 08 Jun 2022 09:49:37 GMT

@Vrushabh Malbari yes, use another tfixedFlowInput to write the current date to the file in the begin of job.