| K101 |
| Advanced Member |
|
|
|
|
| None Specified |
|
| Friday, February 27, 2009 |
| Friday, November 27, 2020 8:14:45 AM |
424
[2.41% of all post / 0.10 posts per day] |
|
Perhaps the schema’s creator has a newer, valid version of the schema available. Otherwise, you yourself could use XMLSpy to fix the problems.
Technical Support
Altova GmbH
|
You can already refer to parameters and other named results in expressions.
Technical Support
Altova GmbH
|
First, uncheck the "Treat empty rows as absent" option in the input component properties.
Then, connect your Rows to each of the two Product items. Insert a filter, then use empty to test for the id and name fields to be, well, empty.
Use a logical-and to combine those two, and connect the logical-and to the filter's bool input.
Finally, move the filter's connection from on-true to on-false.
Also, your schema doesn't look right to me. You probably want one WAREHOUSE element for each row. Since WAREHOUSE is your root, you will only get one. Add a WAREHOUSES root element so it can contain multiple WAREHOUSE elements.
Also, for each WAREHOUSE, the Product element should be allowed to occur between 0 and 2 times only.
All this is demonstrated in the attached examples. Note also how we converted the empty/logical-and/filter structure for the second Product into a User-Defined Function called, "cancel-empties".
Technical Support
Altova GmbH
|
No, that's not presently possible. It'll have to be taken under future consideration.
Technical Support
Altova GmbH
|
If you want to save a value from one mapping for use in a second mapping, store it in a text file.
For help with your exception, you should contact Altova Support directly with your mapping and the files it uses in a zip archive.
Technical Support
Altova GmbH
|
I suspect you included the quotes. You weren't supposed literally to search for ".job", you were supposed to search for the text inside the quotation marks:
Technical Support
Altova GmbH
|
Could you perhaps attach a screenshot of the job?
Technical Support
Altova GmbH
|
Try performing a search from within the Configuration page for ".job".
Technical Support
Altova GmbH
|
Are you previewing output in the MapForce desktop application? If so then of course chained database components won't necessarily reflect the real, complete final output since SQL is only previewed, not automatically done for every component. Try generating program code truly to run the complete mapping logic, or compile to MFX and run using MapForce Server.
Otherwise, better to contact Altova Support directly for this one.
Technical Support
Altova GmbH
|
Sounds like an application for a table footer, since those can repeat on each page. Either that or a page footer. See, for example, "Table headers and footers in PDF output", or Headers and Footer, in the docs.
Perhaps the "Tables with Sub-Totals.sps" example installed along with StyleVision will give you some ideas.
Technical Support
Altova GmbH
|
|
