profiles are EDI Profile mapped to a CSV ( multi-record)
INBOUND EDI : CTT*1*1140
Expected CSV Result : CTT]1]1140
ACTUAL CSV Result : CTT]1]1140]]
Since CTT 03 and 04 are optionals, the separators should only be there if data is available.
In my case, I did not map / deleted some of the destination elements.
Ok but in my usecase in still need to have those values available when a partner send them.
You can set a default value to the empty elements. Then do a find and replace of such elements. Like this
2. Find ]**], **] replace with null
Hope this helps!
Would it be possible to apply a Data Process shape after the map where you do a search/replace?
Search for 2 instances of your delimiter next to each other and replace with a single instance of your delimiter.
Search For: ']]'
Replace With: ']'
Retrieving data ...