Forum Discussion

donepr's avatar
donepr
New Contributor
8 years ago

Date Timestamp error while trying to use the "sql server update" snap?

Hi All, I’m trying to update the target sql server table using “sql server update” snap with the where condition “INSERTTS = $INSERTTS” (INSERTTS is the insert date timestamp) but I’m getting the ...
j_angelevski's avatar
j_angelevski
Contributor III
4 years ago
Copy LinkReport

Hi @KTsnap ,

Assuming the values will be separated by “,” in each field, then we can easily do this with a Mapper.

$.extend(...$.entries().map(val => {[val[0]]: val[1].split(",").sort().join(",")}))

Target path: $

This will work for every field in the input doc.
Sample input data:

Result:

Related Content