IMPORTANT:
this is not a Support Forum! Experienced users might answer from time to time questions posted here. If you need a professional and reliable answer, or if you want to report a bug, please contact Altova Support instead.

Left Join Options · View
Corrado
Posted: Monday, February 15, 2021 10:17:21 PM
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
that
Posted: Tuesday, February 16, 2021 12:24:34 PM
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).
Users browsing this topic
guest

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Use of the Altova User Forum(s) is governed by the Altova Terms of Use.