LAE

 View Only
  • 1.  Excel Node Data - Combine 2 rows into 1

    Employee
    Posted 07-02-2020 20:52

    Hi Guys,

    I've got a lot of data within an xlsx file but the source system didn't out the whole transaction in one single line. It has split the other columns onto the following line, transaction are separated via a blank line.

    I've attached the example of what my data looks like in excel for 2 transactions

     

    Attached files

    example.xlsx

    What i need the data to end up looking like is as per below

    results.xlsx

    I'm hoping that someone can help me out with this..

     



  • 2.  RE: Excel Node Data - Combine 2 rows into 1

    Employee
    Posted 07-07-2020 01:40

    Here is an example of how you can combine the data from the two records.

    In Lavastorm all fields must have a non-Null field name so you cannot output completely Null columns to an Excell file.

     

     

    Attached files

    Join_Records.brg