Data360 Analyze

 View Only

  • 1.  Send email many inputs

    Posted 04-12-2023 05:21



    Suppose i have a column named (Text) with 2 rows(str)

    I connect it to a "Send Email" node.

    The node takes it as an iteration, and send two mails.

    Is it possible to concatenate and get only 1 mail for two or more outputs from (Text)?

    Best regards



    ------------------------------
    Henrik B
    E.ON Sverige
    ------------------------------


  • 2.  RE: Send email many inputs

    Employee
    Posted 04-12-2023 06:40

    No you would need to insert some logic to combine the rows into a single record, de-duplicate the records or filter out the unwanted records before presenting the records to the Send Email node.

    Regards



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



  • 3.  RE: Send email many inputs

    Employee
    Posted 04-13-2023 11:00

    Just to add to what Adrian said,  you might use a Transform node to "aggregate" the data into one record.  Use group.joinStrings() to put the two Text values together.

    out1.Text = group.joinStrings(fields.Text, False, '\n---\n')

    Ernest



    ------------------------------
    Ernest Jones
    Precisely Software Inc.
    PEARL RIVER NY
    ------------------------------