Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
shivaaa786
Contributor
Contributor

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

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.

<storeOrder><cus><ph>12345<ph></cus></storeOrder>

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

Labels (5)
0 Replies