Map empty/blank value in input XML/Json To target XML or json field in cMAP

shivaaa786 — Sat, 16 Nov 2024 01:43:43 GMT

Hi Team ,

We are using talend ESB for our integration project and we are facing a issue with transforming data with cMap.

Talend studio version:7.2.1

patch: Patch_20200522_TPS-3953_v2-7.2.1

First Issue: passing blank/empty value in input structure which customer is sending to target structure field.

eg:

source xml field email--> <order><customer><email></email><phone>12345</phone></customer></order>

when mapped

cMap output is not having the blank value in output xml.

Second issue: setting a constant blank for output xml field in cMap.

if i want some empty tag in output based on target team requirement. eg: <addressline2></addressline2>

we tried setting value using function constant("") . not working. There is one option to set field as mandatory which will generate empty tag but we dont want to use that and that is not a feasible option for us .

we are struggling to resolve this. please help us .

Thanks,

Shiva

topic Map empty/blank value in input XML/Json To target XML or json field in cMAP in Talend Studio

Map empty/blank value in input XML/Json To target XML or json field in cMAP