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 to exclude a certain fields using Transform node?

    Posted 07-10-2024 01:24

    Hi there,

    In the old brain script, I could easily do below code without error even when "{{^DataMonth^}}" column/field is not found from the initial inputs:

    emit *, exclude "{{^DataMonth^}}"

    How can I achieve the same result using the new Transform node?

    Thanks in advance



    ------------------------------
    Daniel Lau
    Meridian Energy
    Christchurch
    ------------------------------


  • 2.  RE: How to exclude a certain fields using Transform node?

    Employee
    Posted 07-10-2024 08:19

    Hi Daniel,

    The Transform Node's ConfigureFields script would include the following code where Field_to_Exclude is the name of the field to be excluded:

    #Configure all fields from input 'in1' to be mapped
    #to the corresponding fields on the output 'out1'
    out1 += in1

    if "{{^Field_to_Exclude^}}" in fields:
        out1 -= fields["{{^Field_to_Exclude^}}"]



    ------------------------------
    Adrian Williams
    Precisely Software Inc.
    ------------------------------



  • 3.  RE: How to exclude a certain fields using Transform node?

    Posted 07-10-2024 16:41

    Thank Adrian,

    That worked well.

    Cheers



    ------------------------------
    Daniel Lau
    Meridian Energy
    Christchurch
    ------------------------------