Forum Discussion

srikotla's avatar
srikotla
New Contributor
7 years ago

Anyone aware on how to insert the data into excel file from a specific line number (in excel sheet)?

Anyone aware on how to insert the data into excel file from a specific line number? My requirement is to insert/create the data in excel file from line number 6. From lines 1-5 I will have the header...
Launched
koryknick's avatar
koryknick
Employee
6 years ago

Try adding an Exit snap after the Emailer with threshold at 0 to fail the pipeline if either source fails. You may also have to set the batch size property in the Emailer to 1 to prevent record batching.

This should allow you to continue to use the Union snap and avoid the “added columns” issue.

fernandezso's avatar
fernandezso
New Contributor II
6 years ago

I just put the exit snap but since one server stills up it is sending the information to the file writers, and creating the csv file with half of the information:

  • dmiller's avatar
    dmiller
    Former Employee
    7 years ago

    I’ve alerted the Doc Manager, but it looks like it may be an issue with Confluence.

  • ankur's avatar
    ankur
    Admin
    7 years ago

    Hi Chris,

    As Diane said, this is an issue with Confluence. That said, if you’re continuing to have access issues, then please try and send the following information to documentation@snaplogic.com:

    • A screenshot of the entire screen in high resolution so we can analyze the error;
    • A HAR File created while the error is shown;
    • The browser’s console log.

    We will remove any private information and send the rest to Confluence Support to try and reproduce this error.

    If this is now resolved, then let us know.

    Thx,
    Ankur