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 sending the file we decided to incorporate the values ( like upsert success, error and delete success , delete error ) in a table format using snaplogic’s HTML TABLE method . We achieved the same but whenever we have say 2 values out of 4 we have two separate tables and if we have 3 values 3 tables are created but we would like to incorporate all the values in a single table view . Please find my pipeline and sample attachment.

As per the above screenshot we would like to have the values Submitted Leave Success and Cancel DEL success in a single table instead of separate table.

Please find my pipeline:

CM_GL_WORKDAY_TO_VEEVA_ABSENCE_INTEGRATION_2020_11_07.slp (109.8 KB)

9 Replies

  • Supratim's avatar
    Supratim
    Contributor III

    @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

      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

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

    • Harsha3's avatar
      Harsha3
      New Contributor III

      Hi Alchemiz,

      I was able to obtain the result as per your method . Thanks since I am new to IT with intermediate knowledge in snaplogic , I would like to know how to create a vertical table . Can you please help me in modifying the code which I published below ( This code creates horizontal table).

      Email Snap HTML Table table.Snap {background-color:transparent;border-collapse:collapse;width:100%;} table.Snap th, table.Snap td {text-align:center;border:1px solid black;padding:5px;} table.Snap th {background-color:Aquamarine;}

      Hi Team,

      Kindly find the attached sheet which contains affiliation and address mismatches in SIQ.

      Success and Error record count:

      Regards,