[resolved] Spaces in the column headers of Excel output file

[Anonymous]

Is it possible to generate an Excel output file that contains column header names that have spaces in them? (Since normally when you create a schema the column names cannot include spaces.)

[Anonymous]

Hi,
You can set your header names with space as "Column" instead of "Schema".
To make it clear, I have designed a demo job for you.
Please have a look at my screenshots
Best regards
Sabrina

[Anonymous]

Thanks! So how would I set this up if the data is coming in from a table rather than a Fixed Flow Input? (i.e. since I cannot include the column names from the table as input data)

[Anonymous]

What Sabrina suggest is to write as first the header as normal output flow with in row and after that with a join write the actual data with another output flow. It is a bit cumbersome but the only way if you restricted on the build-in components.
If you can use user components like tFileExcelSheetOutput you can define the header names as you want without any limits.
http://www.talendforge.org/exchange/index.php?eid=624&product=tos&action=view&nav=1,1,1
Take a look in the documentation linked in the component detail page.

[Anonymous · Accepted solution]

Hi,
Dynamic schema feature allows you to design schema with an unknown column structure (unknown name and number of columns). TalendHelpCenter:How to process changing data structure?
So far, the dynamic schema is not supported by the tFileOutputExcel component. You have to design a fixed schema without space in schema setting of tFileOutputExcel.
Currently, only the databases input and output, the tFileInputDelimited and the tFileOutputDelimited are supported.
Best regards
Sabrina

[Anonymous]

Hi Team

I have created two output excels one is only containing data (different data type data)without headers and another excel contains only header (using tFixedFlowInput component all columns will be string type) , now I want to create final output file with headers from one excel and data from another excel which component should be used & how to use.

[Anonymous]

Guys any updates !!

can we do it, basically I want to have headers with having spaces between words instead of understore "_" . Refer attached screenshot

Merge_issue.PNG

[Anonymous]

Hello,

Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina

[Anonymous]

Using the build-in Excel components you can only use either the column names as headers or you add a header row as normal data row using the tUnit component having the one header row as first flow and the actual data as second flow.

OR you can use the tFileExcel* components from Talend exchange - much more flexible and you could write formulas and use existing styles and templates.