I'm hoping this is a simple question, I couldn't find anything in the forum, documentation or the almighty Google though...
I'm trying to use the XMLStage to transform some rather complex xml documents. The document has several lists that are related by ID and IDREF typed elements. I can't get past an error saying the ID and IDREF key items are not compatible in my HJoin step. Does the HJoin step in the XMLStage not support joining on items of different types?
Thanks in advance.
XMLStage HJoin incompatible keys
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 21
- Joined: Fri Feb 01, 2013 9:13 am
I haven't tried with different types, probably out of habit --- I would just change the datatypes upstream so that they match. No sense wrestling with this inside the Assembly.
Ernie
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
-
- Premium Member
- Posts: 21
- Joined: Fri Feb 01, 2013 9:13 am
Thanks Ernie, this was mostly a learning exercise for myself to get familiar with the Assembly. I was able to move past the error by changing from Strict to Minimal Validation in the Parser step. Somewhere in the documentation I saw a blurb that indicated minimal validation treats all data types as string. Oddly though, I had to remove and add back in the HJoin step before it recognized the changes from the Parser step.