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...
robin's avatar
robin
Former Employee
8 years ago
Copy LinkReport

Hi, as noted in the Script Snap documentation:

Important Notes
The SnapLogic platform (when running the pipeline) can not deal with script-language-specific container types, such as lists and arrays. Those need be represented explicitly by using java native java.util.Map or java.util.List implementations, such as HashMap and ArrayList.

There are further examples listed in the link above. Also, if using the Script Snap is not a necessity, there are ways to use Transform Snap Pack Snaps to group/aggregate multiple document objects together into an array and then add it as a field (e.g. via the Mapper) to an existing object.

walkerline117's avatar
walkerline117
Contributor
8 years ago
Copy LinkReport

Hi, Robin

Yes, i understand i can use groupby and aggregate and using script snap is not a good solution at all.
However, in our case, we are building Ultra pipeline in which groupby or aggregate will not work.

We are building a lot of time sensitive APIs in our company, so Ultra task is the only way to fullfill our requirement.

I will take a look at the java script library you mentioned, some how, the documentation does not provide enough examples, that should be one of the improvement you guys need to work on.

Thanks

  • dmiller's avatar
    dmiller
    Former Employee
    7 years ago
    Copy LinkReport

    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
    Copy LinkReport

    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