Rank: Newbie
Joined: 1/19/2012
Posts: 4
Location: Hyderabad
|
I am converting Excel to XBRL , I was successful in taking Excel data in the format of rows.
But I need to map an Excel File to XBRL where the given Excel file format is as :
Data value1 value2 value3…
Data value1 value2 value3…
As Altova map force is loading the values as rows , I have converted my Excel columns to Rows but I have a problem .I just mapped my source Excel File(IFRS2009 Sample Instance.xlsx) columns to rows (in destination excel “show single cells item for all columns is enabled ). As in figure: Newcoltoroedesign-Copy.mfd
Now the output Excel File I got is correct i.e. it is in the format
Data Data Data…..
Value Value Value……(I checked it in output tab. “xlsx-mapforce.xlsx” File attached).
But with I cant map to XBRL as cells are grouped as single item. Now, I enabled the option “Show separate items for columns”. As in figure: Newcoltorowdesign.mdf
Original Labels of the cells are not being displayed instead A,B,C…. are displayed .I require original labels to map to XBRL and also when I see output excel file doesn’t contain data only it has values . as in figure:excel2.xlsx
Even then the final output when I map to XBRL is correct “Finaloutput.xbrl” file, it has no meaning because I am mapping these values by checking the Original Excel file data from outside.
If labels are displayed directly it can be mapped from the excel to XBRL in tool itself.
File Attachment(s):
 Newcoltorowdesign - Copy.mfd (12kb) downloaded 1,055 time(s).
Newcoltorowdesign.mfd (74kb) downloaded 923 time(s).
xlsx-mapforce.xlsx (3kb) downloaded 1,063 time(s).
excel2.xlsx (3kb) downloaded 1,103 time(s).
Final output.xml (5kb) downloaded 877 time(s).
IFRS 2009 Sample Instance.xlsx (12kb) downloaded 1,020 time(s).
|
Rank: Newbie
Joined: 10/28/2002
Posts: 1,283
Location: AT
|
HI,
what EXACTLY is wrong with the output that you are getting? Please clarify.
|
Rank: Newbie
Joined: 1/19/2012
Posts: 4
Location: Hyderabad
|
Thanks for the reply,
what i want is in the design Newcoltorowdesign.mdf, in the second excel file (given as input to XBRL document) the field names are to be displayed instead of A,B,C,D... so that they can be mapped to XBRL document.pls suggest any solution i am working on this from many days...
Thanks in advance.
Hitha
reddyhitha9 attached the following image(s):
|
