When the Union action block adds a resultset to another resultset, it adds another <Rowset>/<Row> complex to the first resultset including another <Columns> definition as well. I know grids and that will work with this but it means that if I want to apply further actions to the merged resultset, I have to have logic that traverses the multiple rowsets.
I tried append xml like this -
Local.WorkStockpileXml{/Rowsets/Rowset} = MappedXML2_2ndLeg.Output{/Rowsets/Rowset/Row}
but this only appends one row.
Is there a way where I can put the second resultset rows into the same rowset as the first in one step (i.e. without having to loop)?
Cheers.
Message was edited by:
Laurie Paulin
Message was edited by:
Laurie Paulin
Hi Laurie,
in addition to Rick's suggestion, if both Rowsets contain time-series data (i.e. have a DateTime column with time stamps), you can use the TimeInterpolator action to merge them even if they have a different number of rows.
Sascha
Add a comment