Hi, very new to SnapLogic - i built a very simple pipeline to take data from from one server to another.
server1 – Mapper – server2
There is one field in the source database that is too big for the destination database
I was going to take a substring of that field - the code below worked
however, there are null values in the source table.
I tried this - $FieldName.substring(1,8000) ==null?1
but cant get the syntax quite right.
Just looking to take the substring where its not null.