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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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