LAE

 View Only
  • 1.  How to exclude a certain fields using Transform node?

    Posted 3 days ago

    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 3 days ago

    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 2 days ago

    Thank Adrian,

    That worked well.

    Cheers



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