Re:Amazon QuickSight – Business Intelligence by AWS
by mistermann on Wednesday October 07, 2015 @10:19PM
(#10350526)
I'd be interested to learn more about this, I've never heard of anyone importing XML into Excel before - typically "flat files" or SQL datasets are imported into an Excel table, upon which you can quickly build a pivot table, etc. Are you pulling in nested data?
[ Parent
| on HN ]
Re:Amazon QuickSight – Business Intelligence by AWS
by discordance on Friday October 09, 2015 @09:13AM
(#10359743)
I import nested XML into Excel all the time. You will need to create an XML Map first. Look under Excel/Developer/XML Source/XML Maps
Re:Amazon QuickSight – Business Intelligence by AWS
by 5h on Thursday October 08, 2015 @01:57PM
(#10354603)
yes, exactly that, drag an xml file into excel, choose "generate a schema", then you can drag and drop fields from your nested structure,
parent records will be repeated intelligently for nested sub-records.