Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Search and Order a LOG

  1. #1
    Join Date
    Sep 2015
    Posts
    10

    Unhappy Search and Order a LOG

    hello to all I have a problem, I tried to split and order a logfile but I can't because this logs some times change his structure for example this:

    Name:  log_example.jpg
Views: 21
Size:  5.0 KB

    look that the first row has one more Row that the other. I tried with split fields because the ";" is the delimiter and works but when I order the records.
    don't match because the extra row on the previous record:


    Name:  log2.jpg
Views: 24
Size:  18.2 KB

    please help!

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    What would happen if you added a row number to the incoming data, and then used a split fields to rows (split on ; ) and then a split fields (split on = )

    I expect your data would then end up looking like:
    ROW | Type | Value
    1 | TBK_CODIGO_AUTORIZACION | 665206
    1 | TBK_FINAL_NUMERO_TARJETA | 7212

    You could then use a denormalizer step to convert it to:
    ROW | Codigo_Autorizacion | Final_Numero_Tarjeta
    1 | 665206 | 7212


    PS. You'll often get much further if you can post sample data (not screenshots) that the community can play with to try to get the output you want. We're curious people, and want to solve puzzles!

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.