Rank: Newbie
Joined: 2/10/2021 Posts: 8 Location: Canada
|
Hello, I need to use Join Component with Left Join to one of the tables, in database to xml mapping. When record in the joined table exists, it generates XML output fine, like this: <Carrier> <ID>122294341RM0001</ID> </Carrier> But when record in the joined table does not exists, it generates XML output, like this: </Carrier>
I have tried to use substitute-null function, so if ID is null then it will be replaced with empty string "" then it looks like this: <Carrier> <ID></ID> </Carrier>
But how can I achieve that output node Carrier will not be created at all? Thank you
|
Rank: Advanced Member
Joined: 6/16/2006 Posts: 486 Location: AT
|
Add a filter component in the connection to Carrier with the condition that ID exists (use the exists function).
|