Export Data Store Entity to Excel Cannot query because field is a child of a multiple data type

Question

Hi, 
 I'm trying to export the Read-only Grid 
 
 I have this issue due the "ID" is the child of "Q". I know the limitation of selection and Column.

Export Data Store Entity to Excel 
 Either selection or filters are invalid: Cannot query [Q.ID] because [ID] is a child of a multiple data type.

I was wondering if you have any solution to work round this? 
 Thanks

Mike Schmitt · Answer

Create a view that flattens the data per however you will require in your exported Excel file; create a new CDT and DSE referencing that view, and invoke that DSE in your node.