LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  csv import and manipulation

    Employee
    Posted 06-19-2012 07:13

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: khopkins

    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.  RE: csv import and manipulation

    Employee
    Posted 06-19-2012 07:27

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Tim Meagher

    Hey,

    I think the attached graph does what you need.

    Tim.
    Attachments:
    PopulateFields.brg


  • 3.  RE: csv import and manipulation

    Employee
    Posted 06-19-2012 08:24

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: khopkins

    Thanks Tim,

    Perfect works a treat.

    Many thanks
    Keith