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

cjhoward18's avatar
cjhoward18
Employee
4 years ago
Copy LinkReport

FYI this is a string with default defined correctly that is working for me if that String is the true desired type:

  parameters:
  - description: Person ID to get. returns all if null
    default:
    - "empty"
    required: False
    name: putId
    in: query
    type: string
    collectionFormat: multi
jsmith141's avatar
jsmith141
New Contributor III
4 years ago
Copy LinkReport

That was the issue. I completely overlooked it, I apologize I am still learning the yaml format and open API specification. Thanks so much for your help with this!

Best,
James

  • 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