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

dwhansen-cbg's avatar
dwhansen-cbg
Contributor
6 years ago
Copy LinkReport

Basically, yes. I would like to read a file from s3, manipulate it in some way, then write it back to s3.

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

    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 LinkReport

    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