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.  replace a field in a data table with a new field

    Employee
    Posted 06-13-2016 09:45

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

    Originally posted by: JinChen

    I am trying to replace a string with a date. Now I have managed to create the date but I don't know how to emit the whole data table with the old field replaced by the new... can someone please help me?


  • 2.  RE: replace a field in a data table with a new field

    Employee
    Posted 06-13-2016 11:29

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

    Originally posted by: stonysmith

    One way to replace the value in a field is to use the "override" statement:


    d = myField.date("CCYY/MM/DD") #or whatever your format is
    emit *
    override emit d as myField


  • 3.  RE: replace a field in a data table with a new field

    Employee
    Posted 06-14-2016 14:46

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

    Originally posted by: Jaronowitz

    Hello,

    In addition to the previous answer, I would like to suggest to use one of the accelerator nodes designed to solve this type of data type changes.
    The accelerator is called "Change Column" and it allows to specify a new data type and a new name (optional) for a column.

    I hope you find it useful.

    For more information about Lavastorm Accelerator Library:
    http://community.lavastorm.com/threa...erator-Library


  • 4.  RE: replace a field in a data table with a new field

    Employee
    Posted 06-15-2016 07:17

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

    Originally posted by: JinChen

    thanks very much. that's really useful.

    cheers,