Hi there,
Can we use if/else or any logical expression in edi file mapping.
I am generating a edi file on FTP by fetching data from NetSuite. While generating files I am getting few field with empty values. If the field is empty I need to ignore the entire node/segment, Is there a possibility of that.
this is the node/segment from file we need to ignore if {{[subCategory]}} is empty -
{
"name": "REF",
"maxOccurrence": 1000,
"required": false,
"relativeDataPath": "REF",
"elements": [
{
"name": "REF",
"value": "REF"
},
{
"name": "Reference Identification Qualifier",
"value": "SCT"
},
{
"name": "Reference Identification",
"value": "{{{[subCategory]}}}"
}
]
}