Slow PostgreSQL Update Snap
I have a PostgreSQL Update snap at the end of a pipeline. It’s job is to update a column in a row if nothing in an inbound row (matching that data) has been modified. This means that most of the time...
Forum Discussion
We are converting an xml into a csv text file, and the requirement is to change font type to Arial and font size to 11 as per the business requirement.
Now is there a way that we can change it via Snaplogic?
Please Note: The output will be a “.txt” file.
Use a mapper, pass existing fields through, and create a new field $halfAge = $Age / 2
Sorry for my wrong input structure. the below is the correct one. It is a list of objects rather than 3 single objects
{‘items’:[
{
‘ID’:123,
‘Name’:‘Tony’,
‘Age’:24
},
{
‘ID’:124,
‘Name’:‘Sam’,
‘Age’:36
},
{
‘ID’:125,
‘Name’:‘Glenn’,
‘Age’:58
}]}and the view in mapper is like below:
Can you please process now?
Since you’re manipulating an array, you’ll want to look into the “Mapping Root” feature of the Mapper. By pointing the Mapping Root at your array, the Transformations will be applied to the elements of the array instead of the top-level document. Otherwise, the Mapper configuration is the same as suggested by @christwr:
sounds like you want to do something like this which you can do using sl.zip()
sl.zip($items, $genderArray).map(pair => pair[0].extend({ Gender: pair[1] }))
Thanks @cjhoward18, @cstewart
It works fine. Thank you
