Problems with XML Structure

chulett · Post by **chulett** » Fri Dec 26, 2014 5:23 pm

Next time rather than "dots" just use the code tags, they preserve whitespace. Can you show us the XPath Expressions you are using? I'd also be curious what stage you are using, the new XML Assembly I believe it is called?

joycerecacho · Post by **joycerecacho** » Mon Dec 29, 2014 6:16 am

Hello Craig!
Actually I am using the XMLOutputPX stage, and the 'trigger' resource to split the file after a certain quantity of registers.

I used the "XML stage" once - the new one - to read a XML File, and I think it was very complex. It worked after a big help from an IBM guy who is not here anymore.

I never tried to generate a file by this new one.
I think I need some help.

chulett · Post by **chulett** » Mon Dec 29, 2014 9:07 am

I wasn't suggesting you use the new one, simply asking if it was the one you were using since you are running the 11.x version. And you're right, it does add a level of complexity to the process. It shouldn't be a problem to stick with the XMLOutput stage. Can you post the XPath Expressions you are using and the settings you've set in the stage?

chulett · Post by **chulett** » Mon Dec 29, 2014 3:57 pm

Wish I could help, just trying to make sure there's enough information here when someone with more XML smarts wanders by so they can help properly. Thankfully, it's been far too long since I had to worry about stuff like this.

One clarification - when you say "key columns" as in plural, does that mean you've marked more than one? If so, cut it back to a single key column and see if that helps at all.

joycerecacho · Post by **joycerecacho** » Mon Dec 29, 2014 4:26 pm

Hopefully a smart person in xml will help me with this.
Thanks anyway Craig.
About the keys, yes! I use these two.
If I cut them or one of them, or change by another one, it duplicates the tags.
It must be exactly like this.
(at the current version, without the Avs tags).

I tried to add the tag <Avs> but it didnt work.

I dont know...

I'll try to configure the new xml stage.
Does it have the option to split the file?
I didnt find this trigger option.

Thank you so much!!

chulett · Post by **chulett** » Mon Dec 29, 2014 6:25 pm

Unless something has changed, only one "key" column was supported. [shrug] And the new Assembly doesn't support splitting directly from what I've read here but there is a 'trick' you can do with End Of Wave markers or some such to do the same thing. I'll see if I can find the post where Ernie explained it...

Aha! Found it here.

eostic · Post by **eostic** » Mon Dec 29, 2014 11:29 pm

The issue is not about keys per se.....it's about having two entirely independent paths. .....each of which repeats on its own.

Using the old stage, you need to buikd one child path, such as the non avs.....and then save that to a table as a single chunk......then look it up as a value on the rows when you build the avs path farther downstream, and include the formerly built non avs path. This is outlined in the xml best praxlctices document that you will find mentionwd in numerous locations here in the forums.

Using the new stage it can be done in the same assembly, but requures that you learn how to build the paths in a variety of steps, often using one of the join steps to bring the independent paths together.

In either case, you are dealing with independent repeating groups that are not unlike relational tables with a common parent.

Ernie

chulett · Post by **chulett** » Tue Dec 30, 2014 8:52 am

I didn't think it was about the keys, necessarily, was curious if marking multiples would cause an issue. In the old days I recall the job failing if you'd done that, is it allowed now and actually works? Or does it pick one of the multiples to use?

joycerecacho · Post by **joycerecacho** » Tue Dec 30, 2014 10:42 am

chulett wrote:I didn't think it was about the keys, necessarily, was curious if marking multiples would cause an issue. In the old days I recall the job failing if you'd done that, is it allowed now and actually works? Or does it pick one of the multiples to use?

It perfectly works!
And it must be these two keys, otherwise the result is not ok.

(at the current version, without Avs Tags)

eostic · Post by **eostic** » Tue Dec 30, 2014 1:07 pm

The keys for output links help establish the aggregatiion needed to build a single path hierarchy. I wouldn't necessarily trust the multiple keys.....ultimately it is really just establishing a lowest level repetition element......so test it carefully.

Either way, the key indicators have no impact on building independent paths....

Ernie