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.  How do I add a new column?

    Employee
    Posted 11-13-2015 12:36

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

    Originally posted by: kmehta@maassmedia.com

    I am new to lavastorm and I had couple questions:
    1) I took a database and filtered it for dates that I wanted. My next step is to trim one of the fields called "Number" and take only first 6 characters from the string of that field. And next step is to add a new column where the value is 1 for every record in the table.

    Can someone help me with this?

    Thanks


  • 2.  RE: How do I add a new column?

    Employee
    Posted 11-15-2015 17:50

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

    Originally posted by: stonysmith

    It's very simple. Add a filter node with this code:

    emit *
override emit Number.left(6) as Number
emit Call = 1