Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Problems with txt input file

  1. #1

    Smile Problems with txt input file

    I´m doing some tests with Kettle (a prove of concept), and I got into trouble on the "easiest" part: text input file txt configuration.

    The objective of this job is to read a parameter table (that contains some "where" clauses as well as database conection information.

    I have followed the logic of the all tables, and I got a loop where I got lots of txt files generated (all on the same format).

    Now I need to load all this files on a table.

    I am trying to use an input file to load my final table, but I am not being able to get it done (I cant make the wildcard work on Windows XP).

    I have atached the JPG of this input file configuration.

    If you find any use on this (as this job is almost a copy of the "copy all tables example"), I can also upload all the jobs and transformations.

    Thks in advance ,

    Reinaldo A Vasconcellos
    Brazil
    [IMG]file:///C:/DOCUME%7E1/xsrs587/LOCALS%7E1/Temp/moz-screenshot.jpg[/IMG]

    [IMG]file:///C:/DOCUME%7E1/xsrs587/LOCALS%7E1/Temp/moz-screenshot-1.jpg[/IMG]
    Attached Images Attached Images  

  2. #2

    Default

    I also tryed the Get File Name and set File name and could see the variables on a Display Box, but could not make it works on the Txt Input File.

    Bellow is my system config:

    Kettle - Spoon: 2.5
    OS: Windows XP Profession, SP 2

  3. #3
    Join Date
    May 2006
    Posts
    4,882

    Default

    Try .* as wildcard... the wildcards are regular expressions.

    Regards,
    Sven

  4. #4

    Default

    Thks for the replay Sven.

    I tryed the wildcard as you instructed me and it worked fine.

    Thks a lot,
    Reinaldo

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.