topic Re: tFileOutputDelimited producing null values in Talend Studio

tFileOutputDelimited producing null values

JM39 — Wed, 11 Mar 2020 14:44:35 GMT

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!

Re: tFileOutputDelimited producing null values

Anonymous — Wed, 11 Mar 2020 14:51:59 GMT

Hi,

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

Re: tFileOutputDelimited producing null values

JM39 — Wed, 11 Mar 2020 15:29:52 GMT

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.

Re: tFileOutputDelimited producing null values

Anonymous — Wed, 11 Mar 2020 16:05:17 GMT

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

Re: tFileOutputDelimited producing null values

JM39 — Wed, 11 Mar 2020 16:33:47 GMT

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

Locations list for input into Configuration Workbookv5 JM.xls

Re: tFileOutputDelimited producing null values

JM39 — Fri, 13 Mar 2020 11:03:59 GMT

I managed to resolve this - thanks for the help!

Re: tFileOutputDelimited producing null values

manodwhb — Mon, 16 Mar 2020 03:48:51 GMT

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

Re: tFileOutputDelimited producing null values

JM39 — Mon, 16 Mar 2020 09:08:28 GMT

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