Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Text File too big in export to text

  1. #1
    Join Date
    Oct 2016
    Posts
    10

    Question Text File too big in export to text

    Hello, I have one issue on my transformations... I have to make a text output from a xml, well when I use my transformation (it haves just TABLE INPUT and TEXT OUTPUT) it gives me a text with 9,53 MB and when I copy and paste the xml from the database (using the same query) my text file passes to 20 Kb
    I dont know what to do to fix this...
    The image of my transformation:

    Name:  form.png
Views: 30
Size:  3.7 KB

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

    Default

    The default behaviour of Text-File-Output is to format every field according to its metadata.
    A Text-File-Output setting on the Content page labeled "Fast data dump" lets you skip formatting when enabled.
    But if you need certain fields to be formatted (like date fields) you can use trimming on the String fields, instead.
    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.