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 |
3 Replies
-
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
-
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.
-
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