@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
Hi Alexandar, curious, if scenatio below is possible to do in snaplogic:
Scenario first row has fixed length 10 fields
"Audi";"5558";"TypeA8";"2022";"Diesel";"";test1;"";"";"Germany";
Second row has 5
"Mercedes";"";"TypeS";"2022";"India";
there can be empty space in both in first row and in second row as well. Is it possible instead of this:
"Audi";"5558";"TypeA8";"2022";"Diesel";"";test1;"";"";"Germany";
"Mercedes";"";"TypeS";"2022";"India";"";"";"";"";"";
get this? (get rid of empty fields(from field 6 to field 10)
"Audi";"5558";"TypeA8";"2022";"Diesel";"";test1;"";"";"Germany";
"Mercedes";"";"TypeS";"2022";"India";
thank you
Hello SL12345,
Could you please try with the following sample pipeline?
In the Map - Fields Snap expression we have a filter that filters out the empty values.
Let me know if this helps you.
Regards,
Aleksandar.
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
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
