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.  Check for Primary and Mandatory Fields for Null for Source file

    Employee
    Posted 07-21-2014 03:55

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

    Originally posted by: sree

    Hi Team,

    If i have source as a file(XLSX,XLS,fixed width,CSV) ,how can i validate the data for Primary and mandatory fields if they are null or not .


    Regards,
    Sree


  • 2.  RE: Check for Primary and Mandatory Fields for Null for Source file

    Employee
    Posted 07-22-2014 02:31

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

    Originally posted by: Tim Meagher

    Hi,
    You would first need to read the data in using the Excel File node for XLS, XLSX or using the CSV or Delimited File node for the CSV file.
    For fixed width files, you would use the Fixed Format node.

    Once the data has been read into the LAE, you should then just be able to pass it through a filter node, and use the brainscript isNull operators on the various fields to see if the required fields are present.
    See the brainscript help on the isNull operator for more information.

    Tim.


  • 3.  RE: Check for Primary and Mandatory Fields for Null for Source file

    Employee
    Posted 08-03-2014 09:51

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

    Originally posted by: andycooper

    You could also use the Data Analyzer Node (Profiling and Patterns) to check for null values.