tFileOutputDelimited producing null values

[JM39]

Hello

I'm trying to convert a tFileInputExcel file to tFileOutputDelimited (.dat).  I have created the tMap to map the columns but five of the columns are coming out with all null values even though there are values in the input file.  I attached some screenshots of the input, map & output I'm seeing.  Help appreciated!

[Anonymous]

Hi, 

Can you explain why you are using object type content as input ?

[JM39]

Hi Pierre

Thanks for the quick response.  Actually I only just started using Talend yesterday & I haven't had any training other than the online docs, so I'm not properly clued up on the difference.  Would that be the issue?  Should it be something else?  TIA.

[Anonymous]

Use tlogrow components between your components to locate when the data comes null, it is probably after the tFileExcelInput , your columns are not pointing rightly the expected data.

I would be glad to help you if you can share us an excel file sample

[JM39]

Thank you very much - I've attached my excel input file

Locations list for input into Configuration Workbookv5 JM.xls

[JM39]

I managed to resolve this - thanks for the help!

[manodwhb]

@JM39 , Please share the solution so that it will help to others.

[JM39 · Accepted solution]

I think it was due to the column headers on my input file not being exactly correct