MashUp: Converting XLS tables

Posted by Phil Knirck

Posted on Thu, 10/22/2009 - 21:09 in MashZone

I have a question about converting XLS files into a data feed. I have a table that looks like this

US	Actual	Actual	Actual
Month	Jan	Feb	Mar
X1:	$ 11	$ 5.00	$ 7.00
X2	$ 200.46	$ 7.14	$ 8.68

I now need to create something that looks like: X1, $11, Jan, Actual X2, $200, Jan, Actual X1, $5, Feb, Actual etc So basically I need to use column values as row values, or interpret column values as values. However what I have seen I cannot access any of the column names in any way. How do I deal with this?

27.5k

by Sebastian Stein

Posted on Fri, 10/23/2009 - 13:07

Hi Phil,

do you want to do this kind of conversion outside of or inside ARIS MashZone? I think it might be easier to do it with a small makro directly in excel.

Sebastian

by Phil Knirck Author

Posted on Fri, 10/23/2009 - 15:26

What I have actually done is intepret every row seperately as data feed that works but is a lot of work. So I think, you might be right about using excel for this.

by Stephan Freudl

Posted on Mon, 10/26/2009 - 12:21

Hi Phil,

I must aggree: You hit a weak spot. ARIS MashZone depends on row-based data as it expects different semantics in each column. As long as there is no transpose operation I suggest to adjust the data source.

Regards

Stephan

MashUp: Converting XLS tables

Featured achievement

Leaderboard

Follow us

View posts by tag