on 09-06-2007 1:50 PM
I have multiple rowsets (xml files) which I want to calculate subtotals from. Each xml data set has identical columns. If I union all the files together, the xml content contains multiple rowsets and the Crosstab function does not give me a summed value of each column, but instead it creates a column for each column in each rowset.
The Normalize and the rowset combiner transform both combine rowsets by appending the second dataset into new columns, is there any way to append the data into new rows instead?
Because my final file is going to have something over 30,000 rows (14Mb), I am reluctant to use a repeater on each row of each file to combine it into a new rowset. Is there an efficient way to handle this calculation?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sue,
Try using Join instead of Union.
-Sam
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sue,
I believe that we are off on the wrong foot here...all things aside...
Join will work for your scenario when combined with other actions for your calculation and it will be easier to maintain than a stylesheet which will be beneficial to you in the end. Please do not be too quick to judge the solution
As for the error message that's one for support, what was the error in the logs?
-Sam
User | Count |
---|---|
11 | |
6 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.