Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Join Rows in many Tables

  1. #1
    Join Date
    Nov 2013
    Posts
    3

    Default Join Rows in many Tables

    Hi everybody,

    I have read many CSV-Files with the format "name", "symbol"(key), "value". The CSV-Files are created every 30 minutes with a time stamp in the filename
    The fields are for example:
    "Firma 1","F1","84"
    "Firma 2","F2", "67"
    "Firma 3...."

    I have circa 30 CSV-Files of this type and I want following:
    I need a Operation, that I have for every "symbol" the chronological sequence in one table:
    Table name: "<symbol>",
    with the values:
    "2013-11-18 07:00PM", "84"
    "2013-11-18 07:300PM", "85"


    I hope yxou understand my problem, because I dont speak english very well.

    Best regards,
    Diego

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

    Default

    Specify a short filename field on the advanced tab of your Text File Input step.
    That way the file's timestamp becomes a regular field you can dissect any way you see fit before shooting the rows to that table.
    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.