Results 1 to 3 of 3

Thread: csv import and manipulation

  1. #1

    Default csv import and manipulation

    Hi all,

    I am trying to import and manipulate a set of data from what is effectively a log file where not all of the columns in the data are populated.
    IE the first row contains timestamps and key values and then data values but after this record the the key values are blank until a new event starts as below.

    Job Type,Creation Time,Due Time,Process Step
    blah1,30/04/2012,01/05/2012,start
    ,,01/05/2012,Create
    ,,01/05/2012,VIP-IN
    ,,01/05/2012,VIP-OUT
    ,,01/05/2012,Print
    ,,01/05/2012,Insert
    ,,01/05/2012,Holding
    ,,01/05/2012,Dispatch
    blah2,30/04/2012,01/05/2012,
    ,,01/05/2012,Create
    ,,01/05/2012,VIP-IN
    ,,01/05/2012,VIP-OUT
    ,,01/05/2012,Print
    ,,01/05/2012,Insert
    ,,01/05/2012,Holding
    ,,01/05/2012,Dispatch

    what i need to be able to do is import the data and then manipulate the it so that the key value fields are populated with the first row until a change occurs.

    Eg as below

    Job Type,Creation Time,Due Time,Process Step
    blah1,30/04/2012,01/05/2012,start
    blah1,30/04/2012,01/05/2012,Create
    blah1,30/04/2012,01/05/2012,VIP-IN
    blah1,30/04/2012,01/05/2012,VIP-OUT
    blah1,30/04/2012,01/05/2012,Print
    blah1,30/04/2012,01/05/2012,Insert
    blah1,30/04/2012,01/05/2012,Holding
    blah1,30/04/2012,01/05/2012,Dispatch
    blah2,30/04/2012,01/05/2012,
    blah2,30/04/2012,01/05/2012,Create
    blah2,30/04/2012,01/05/2012,VIP-IN
    blah2,30/04/2012,01/05/2012,VIP-OUT
    blah2,30/04/2012,01/05/2012,Print
    blah2,30/04/2012,01/05/2012,Insert
    blah2,30/04/2012,01/05/2012,Holding
    blah2,30/04/2012,01/05/2012,Dispatch

    I am assuming i will need to import this first and then use a filter to alter the data but any help will be appreciated.

    Keith

  2. #2
    Lavastorm Employee
    Join Date
    Aug 2009
    Location
    Cologne
    Posts
    513

    Default

    Hey,

    I think the attached graph does what you need.

    Tim.
    Attached Files Attached Files

  3. #3

    Default

    Thanks Tim,

    Perfect works a treat.

    Many thanks
    Keith

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •