Forum Discussion

Harsha3's avatar
Harsha3
New Contributor III
5 years ago

Table creation when sending mail

Hello, I was designing a pipeline which includes salesforce upsert and deletion . Obviously error view will be captured for the upsert and deletion operation and while sending the mail along with s...
Supratim's avatar
Supratim
Contributor III
5 years ago
Copy LinkReport

@Harsha3 - Try below approach-
Use group by N make it as 0 so all record should be grp by in one array, then change the table data path with your group name like below-

  • Harsha3's avatar
    Harsha3
    New Contributor III
    5 years ago
    Copy LinkReport

    Hi Supratim,

    Thanks for the reply I have tried that approach still we get two rows instead of one for having two values.

    Thanks,
    Harshavardhana

    • del's avatar
      del
      Contributor III
      5 years ago
      Copy LinkReport

      @Harsha3,
      You might try the Aggregate snap using the MAX function:

      • Harsha3's avatar
        Harsha3
        New Contributor III
        5 years ago
        Copy LinkReport

        Hi del,

        Thanks so much it works! . May i know the working procedure here because without this method we would have got two rows so does it like the inherent table property we use in mail sender