Accented characters not being interpreted
Hello
Project to move software environment to a new servers. Moved pipelines, accounts, tasks to a new server. The automated load process utilizing csv does not interpret accented characters prop...
Forum Discussion
Thanks for the replies.
In the end, I figured it out. I have the date as a VarChar(50) data type field coming from a staging table, in which the date is of the form, “2019-08-23 14:34:42” (without the quotes), and a destination table with a DateTime2(7) data type, so the date is of the form “2019-08-23 14:34:42.0000000” (again, without the quotes).
I was getting what looked like identical results, in the JSON Output views of each query, after I applied the formula Date.parse($CurrentDate).toLocaleDateTimeString() to the stage table date, and was doing nothing to the destination table’s date.
What made it work was applying the formula $CurrentDate.toString() to the DateTime2(7) value, and then suddenly the Diff Snap had only Unmodified rows. The data still looks exactly the same in both output views before the Diff, which tells me that what looks the same is not necessarily the same internally to Snaplogic.
Thanks again!
David
Thanks for that, your reply helped solve another problem I had, I’ll get back when I’ve confirmed its also a solution for this issue.
Hi,
I have a scenario, where the api post will only take 100 records per minute.
My requirement is to post 100 records a batch with a wait time of 1 minute between each post.
Hi @karthik_dhina,
You can acheive this with Script snap.
Inside which you can make the snap to wait for some time.Here is one mine post in which you can find the script.
Script is written in python and simply just calls sleep function.
https://community.snaplogic.com/t/throttle-bot-or-other-loop-delay-mechanism/11423/2?u=viktor_nHope this will help.
Regards,
Viktor
