topic Re: Columns missing data when exported as csv or xls in Talend Studio

Columns missing data when exported as csv or xls

Anonymous — Wed, 02 Nov 2016 20:20:56 GMT

I have added two new columns and when the file is exported to csv or xls, the colums are blank.
Added Person Status column and populated with ACTIVE
Added Company Status column and populated with Indirect
Why is the date removed from the columns upon export?

Please note these are not date fields but rather just text fields. They appear in the Talend view but when exported they appears a new column not person status or company status as shown in Talend.

Re: Columns missing data when exported as csv or xls

talendtester — Wed, 02 Nov 2016 20:39:53 GMT

So your job is:
csv or xls > tmap > csv or xls

Did you map the date column to the output in the tmap?

Re: Columns missing data when exported as csv or xls

Anonymous — Thu, 03 Nov 2016 05:17:03 GMT

Can you please share your job design with component screenshot?

Re: Columns missing data when exported as csv or xls

Anonymous — Thu, 03 Nov 2016 19:04:44 GMT

Let me be clear, the column are not missing, but rather empty when exported. But the data preparation appears to be correct while creating the recipe, it is just upon exporting the file that the column contain no data. This continues to occur this morning. Am I doing something wrong?

Re: Columns missing data when exported as csv or xls

talendtester — Thu, 03 Nov 2016 19:18:51 GMT

Without a picture of your job and the components it's hard to guess what is going wrong.

Re: Columns missing data when exported as csv or xls

Anonymous — Fri, 04 Nov 2016 13:02:09 GMT

I am unsure of what you are referencing as job components.
Every list I cleanse right now is different so creating a single recipe to fit all is not applicable at this time.
As I am new to using Talend Data Preparation, it is trial and error right now.

Re: Columns missing data when exported as csv or xls

Anonymous — Fri, 04 Nov 2016 13:05:48 GMT

there is a final screen shot but cannot upload it.

Re: Columns missing data when exported as csv or xls

talendtester — Fri, 04 Nov 2016 15:20:44 GMT

It doesn't look like you are using Talend Open Data Integration.
I think you are using another Talend product, your question should be moved to a different section of the forums.