Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Textfile output problem

  1. #1
    Join Date
    Jun 2017
    Posts
    25

    Default Textfile output problem

    Greeting,

    I got problem when integrating data from MSSQL database to textfile output.
    I executed the textfile output to 1 row per textfile. But some of the data from the database when viewed in the textfile output got 3 row of data from the 1 row of data in the MSSQL database.

    is there any data encoding in MSSQL that create this problem? i try to use the same type of data in oracle and its work just fine.

    Name:  error.jpg
Views: 33
Size:  5.5 KB
    data from database

    Name:  CaptureErr.jpg
Views: 35
Size:  7.7 KB
    textfile output

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Check your database fields for embedded linebreaks.
    So long, and thanks for all the fish.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.