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.  Excel Output

    Employee
    Posted 12-03-2013 07:07

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

    Originally posted by: Steve

    When data results exceed the number of rows in excel is it possible to split the data in half and put on separate tabs in excel? For example; data results have 2,000,000 records, output 1M to one tab in excel and the other 1M to another tab.


  • 2.  RE: Excel Output

    Employee
    Posted 12-03-2013 07:47

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

    Originally posted by: xathras

    Hi Steve,

    Of course you could hash split the results, or have a python or Java node that dynamically splits the files once you get to the maximum record count of excel. Want to say I've seen a solution for this before. Let me see if I have an example.

    Wayne


  • 3.  RE: Excel Output

    Employee
    Posted 12-03-2013 08:12

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

    Originally posted by: xathras

    here is a non elegant way of solving the problem
    Attachments:
    example.brg