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.

Profile: Corrado
About
User Name: Corrado
Forum Rank: Newbie
Real Name:
Location
Occupation:
Interests:
Gender: None Specified
Statistics
Joined: Wednesday, February 10, 2021
Last Visit: Monday, March 15, 2021 7:14:00 PM
Number of Posts: 3
[0.02% of all post / 0.01 posts per day]
Avatar
Last 10 Posts
Topic: switch destination database
Posted: Monday, March 15, 2021 7:11:35 PM
Thank you!
Topic: switch destination database
Posted: Wednesday, March 3, 2021 2:39:38 PM
Hello,
I have mapping, implemented to import XML files into MS Access database.
Now I need to do the same import into MS SQL database.
Table names and column names in both databases are identical.
Is it possible to just change destination database, and re-use existing mapping?
I have tried, but "old" Access tables keep showing with red question marks..
Thank you
Topic: Left Join
Posted: Monday, February 15, 2021 10:17:21 PM
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

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