Talend Data Quality analysis is not reading data from a CSV file

Problem Description

If you create a File delimited connection to a CSV file and define the schema, you can see the contents of the file by right-clicking on the connection element in the Metadata section, and selecting Data Viewer. You can also see the schema, so the file is reading correctly.

 

The issue is that when switching to the Profiling view, if you select Column analysis and select the added connection, it shows up in the Data Preview configuration, but if you click Refresh Data, nothing shows. TDQ-14743 was filed for this issue.

 

Steps to reproduce

  1. Create a file connection, using CSV mode.
  2. Create a column analysis, and select columns from this file connection.
  3. Click Refresh Data. No data appears.

 

Workaround

Create the file connection in Delimited mode (this is the default mode).

 

Solution

This issue has been resolved in 6.4.2, 6.5.1, and 7.0.1.

Version history
Revision #:
6 of 6
Last update:
‎04-14-2019 02:20 PM
Updated by: