Columns missing data when exported as csv or xls

One Star

Columns missing data when exported as csv or xls

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.

Nine Stars

Re: Columns missing data when exported as csv or xls

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

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

Re: Columns missing data when exported as csv or xls

Can you please share your job design with component screenshot?
One Star

Re: Columns missing data when exported as csv or xls

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?
Nine Stars

Re: Columns missing data when exported as csv or xls

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

Re: Columns missing data when exported as csv or xls

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.
One Star

Re: Columns missing data when exported as csv or xls



there is a final screen shot but cannot upload it.
Nine Stars

Re: Columns missing data when exported as csv or xls

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.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog