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.  Removing NUL rows after importing from Excel

    Employee
    Posted 09-18-2014 18:12

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

    Originally posted by: dglavastorm

    Hi, sometimes when importing Excel data I end up with rows and rows of NUL fields (over 1000 in the latest import). Although i can't find out exactly why, I assume the rows in the Excel sheet, despite being blank, have formatting or something that LS thinks they are part of the data.

    Is there anyway to

    In the Excel Import node, tell it to ignore blank rows
    or
    As a filter or other node, remove a row made up entirely of NULL values.

    Thanks,

    Dave


  • 2.  RE: Removing NUL rows after importing from Excel

    Employee
    Posted 09-19-2014 08:53

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

    Originally posted by: stonysmith

    On the Exception Behavior tab, select NullRowAction=Ignore


  • 3.  RE: Removing NUL rows after importing from Excel

    Employee
    Posted 09-21-2014 16:00

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

    Originally posted by: dglavastorm

    Perfect, thanks.