News for hackers. Stuff that matters.
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?
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.