Regarding Column name with space load from DB to file

[BA621858188]

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

[Anonymous]

Hi

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

[BA621858188]

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

[Anonymous · Accepted solution]

@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

[BA621858188]

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

[Anonymous]

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