Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: Get everthing on just one file

  1. #1
    Join Date
    Dec 2013
    Posts
    1

    Unhappy Get everthing on just one file

    Hello.

    I'm doing an transformation, and since i'm just an beginner on kettle i would like to have some help from you...
    This is for university so just academic interest.
    I have an text file (logfile.log) where i have some parts that are xml. These parts of text starts with xml header and then the root tag is <root>.
    I'm using Regex Evaluator to pick 2 groups <root></root> and other part (number with 14 digits and an letter).
    Then using a filter i get only lines where de digitis are present.
    After i do the sort ascending using the digits field.

    Now my problem is that i have 4 steps to get data from xml, and they work good, but at the end i need to create only one xml file like this:
    <PCBS>
    <PCB>
    <id>00000000000000T</id>
    <partreceived> </partreceived>
    <receivedxml> </receivedxml>
    <partprocessingstart> </partprocessingstart>
    <partprocessed> </partprocessed>
    </PCB>
    </PCBS>

    and those fields inside PCB needs to be from the serial number (14digits) and i don't know you to make that. I was trying for long time, and need help.
    Attached Files Attached Files

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.