Forum Discussion

Tanmay_Sarkar's avatar
Tanmay_Sarkar
New Contributor III
4 years ago
Solved

Split hours into back dated days based on total hours

Hello All, I’ve stumbled upon a scenario, where I need to split the JSON object into n number of objects (backdated) if the total hours coming in from the source crosses 24, it should split until t...
expression_language
json_splitter
mapper
pipeline
sample_pipeline
transform
  • koryknick's avatar
    koryknick
    4 years ago

    Hi @Tanmay_Sarkar - this is a complex requirement. There are ways to have SnapLogic create multiple documents from a single document, but here you have multiple documents that need to first be analyzed and summarized to determine the total value, then split the “overflow” values into multiple documents. My recommendation is that you look into the Script snap and use the language of your choice (Javascript, Python, Ruby) to do this.

koryknick's avatar
koryknick
Employee
4 years ago

Hi @Tanmay_Sarkar - this is a complex requirement. There are ways to have SnapLogic create multiple documents from a single document, but here you have multiple documents that need to first be analyzed and summarized to determine the total value, then split the “overflow” values into multiple documents. My recommendation is that you look into the Script snap and use the language of your choice (Javascript, Python, Ruby) to do this.

  • Tanmay_Sarkar's avatar
    Tanmay_Sarkar
    New Contributor III
    4 years ago

    Thank you @koryknick

    This makes sense. Depending on a script was definitely one of the options (and we managed to get this done with the help of a JavaScript).
    Just thought to share this in the community and understand if there’s a way to get this done in SnapLogic directly.

    Regards,
    Tanmay