Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Data Prep 2.5 Export Fail

Has anyone been experiencing problems with data exports using Data Prep 2.5?  

 

I've been using Data Prep for about 5 Months and like it, but this is the second time I have had a problem where a preparation will fail to export. 

It creates a file (CSV, XLSX) but it contains no data.  The preparation appears to do all my adjustments correctly.

 This has occured on preparations that previously worked fine.  Just all of the sudden the become broken.  The only way I have found around it is to recreate the preparation.

 

Any help would be appreciated?

FYI.  My OS is Win 10.

 

Thanks.

Labels (2)
1 Solution

Accepted Solutions
skermabon
Contributor
Contributor

Hello

Did you remove a column in your Excel sheet before update it in Data Preparation? In logs we see the preparation expected 16 columns, and the dataSet contains only 15.

Have a nice day.

View solution in original post

4 Replies
skermabon
Contributor
Contributor

Hello.

I have a question about your version of Talend Data Preparation.

If your version is a free version. Please add your logs files as attachment (your logs are on <USER_HOME>\AppData\Roaming\Talend\dataprep\logs directory on Windows), and add more information on your preparations and how you call an export (screenshots will be helpfull).  Another question, when you open the preparation, you see the content of your dataSet?

 

If your version is en Enterprise version, call the Talend support.

Have a nice day

Anonymous
Not applicable
Author

Hi,

It is the free version.  We have an Excel spreadsheet from which we have created two datasets, each pointing to a different sheet in the Excel file.  From that I have a preparation for each dataset that does some pretty basic things (remove columns, Replace values, etc.).  The results from each preparation look fine inside the Talend Screen.    We use the export function to push the results to a CSV file with the following Criteria: Field Delimiter=Comma, Text Enclosure=", Escape Character=", Values to enclose=Text Only, and Encoding=UTF-8.

 

When we do an export the file is always 0 KB. 

 

The preparation worked on previous updates of the dataset, but has failed on the latest version of the dataset. 

Since the preparation looks inside the Talend Screen, I would think that there shouldn't be a problem with the data itself.

Log files attached.

 

Thanks for your help! 


app.log
skermabon
Contributor
Contributor

Hello

Did you remove a column in your Excel sheet before update it in Data Preparation? In logs we see the preparation expected 16 columns, and the dataSet contains only 15.

Have a nice day.

Anonymous
Not applicable
Author

That was it.  Thank you for your help.