Forum Discussion

SL12345's avatar
SL12345
New Contributor III
2 years ago
Solved

Split string into rows and save it to file row by row, not in one string

Lets say i have this input string in my mapper: "Mercedes;6658;TypeS;2022;\r\nAudi;5558;TypeA8;2022;Diesel" How can i save it to csv file as single rows? in this example it should be: Mercedes;665...
  • jcornelius's avatar
    jcornelius
    4 years ago

    @Damone
    do it all in SQL
    ie
    IF EXIST(Select id from table_x where id=@id)
    BEGIN
    UPDATE table_x set col1=@col1 where id=@id
    END
    ELSE
    BEGIN
    INSERT INTO into table_x (id,col1) values(@id,@col1)
    END

ptaylor's avatar
ptaylor
Employee
4 years ago
Copy LinkReport

Change the Memory Sensitivity setting from None to Dynamic. That allows the Group By Fields snap to break each group of documents with the same field value across multiple output documents (“parts”) when memory is constrained. The part size varies dynamically as memory conditions change.

  • umashankar316's avatar
    umashankar316
    New Contributor II
    7 years ago
    Copy Link

    Hi Christwr,

    Issue is happening after have upgraded application to 4.17.

    We have similar kind of integration which will convert IDOCS to xml and process for downstream through snaplogic application some of ter transactions not showing time stamp of the execution.

    Thanks,
    Umashankar

  • Surendar's avatar
    Surendar
    Contributor
    7 years ago
    Copy Link

    Yes even we are also faced the same issue for existing child pipelines, Also reported to SnapLogic support with other few issues too after 4.17 release.

    SnapLogic team responded us they are going to provide patching for this. probably in a couple of days. Hope it will resolve it soon.

    Regards
    Suren