Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Get data from XML problem

  1. #1
    Join Date
    Jun 2009
    Posts
    17

    Default Get data from XML problem

    Hello:

    I have search the forums and I do not find any answer to my problem, so I begin a new thread... excuse me if it is already answered elsewhere.

    I have a sample XML file like the one attached. Well, I am able to read the companycode and the company address, and also I am able to read the company employees, but I read them as a unique field, and what I want to do is to read the empid and the employee name to write them in a table. If I change the XPath to read /xml/company/employee, then I cannot write the companycode to the employees table, defined as

    CREATE TABLE `employee` (
    `Name` varchar(255) NOT NULL,
    `EmpID` int(11) NOT NULL,
    `CompanyCode` varchar(255) NOT NULL,
    PRIMARY KEY (`EmpID`),
    KEY `CompanyCode` (`CompanyCode`),
    CONSTRAINT `empleados_fk_1` FOREIGN KEY (`CompanyCode`)
    REFERENCES `empresas` (`Companycode`)
    ON DELETE CASCADE
    );


    Thanks in advance.
    Attached Files Attached Files

  2. #2

    Default

    Get data from XML problem
    problem? I don't see problem :-)


    http://wiki.pentaho.com/display/EAI/Get+Data+From+XML


    Samatar
    Last edited by shassan2; 06-04-2010 at 10:55 AM.
    Samatar

  3. #3
    Join Date
    Jun 2009
    Posts
    17

    Default

    Quote Originally Posted by shassan2 View Post
    Thank you very much

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.