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.  generate a NULL record while maintaining data type

    Employee
    Posted 01-31-2015 08:58

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

    Originally posted by: ryeh

    Here is an example of taking any data set and creating one record of null values while maintaining the same data types across all fields.
    Attachments:
    generateNullRecord.brg


  • 2.  RE: generate a NULL record while maintaining data type

    Employee
    Posted 01-08-2016 16:05

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

    Originally posted by: ryeh

    On a related note, if you want to create an output with ZERO records but have a record of the fieldnames and data types, you can use a filter node. This comes in handy as the first input to a Cat node. The Cat node uses the column order of the first input, so if you've re-ordered the columns but want the columns in the same order as the data source, this is a good trick.
    Attachments:
    generateZeroRecords.brg