Export function from Data Designer

Hi @harriseilenberg 

Thanks for posting this. I have a few questions for you - 

• Do you want to use excel to validate the data? 
• What all actions to you perform to validate? 

We have the explore tab of Data Designer so that you can explore your data and make sure this is what you need. I wanted to understand if this is able to solve your need to review the data and if it doesnt, where does it fall short. 

Hi @rakesh,

Yes, excel would be the best format for the export.

I’m typically validating the data against another data source, so VLOOKUPs and pivot tables primarily.

I would also like to use the data designer for one-off analysis from time to time. Rather than creating multiple reports, exporting those and joining in excel, it would be great to create a single data space and be able to export the results. This information typically needs to be distributed internally via Google sheets / slides.

+1, it would be very helpful if we could export reports directly from Data Designer 

We are considering multiple export options from data designer as a part of the medium term roadmap

Just came across this issue and thought it was a little silly that I would be required to make the dataset universally available when the only reason I was creating this design was to for a one-off anomaly data cleanup. +1 on this please!

Hi All,

We are planning on adding S3 export capability to Data designer (kind of like rules, but much simpler) in a relatively shorter time horizon.  Excel exports in explore page is something that's still a bit further away. I’ll need more votes/comments to get this idea prioritized over other important ones.

I was going to make a post about this, then saw it already had one, and apparently, I’d even voted for it.

Just adding my thoughts on this to help with prioritization:

What I would use it for, and I think others as well, is just to export a table of data from the explore stage of DD. The export needs to be a really simple, one button process similar to exporting data from regular reporting. I’d imagine it at the top or bottom in these general areas somewhere:

Like others have said, this is mostly for validation, POC against other data so speed and simplicity are really the important thing. Start simple and then add to it if needed.

I came across this need recently for troubleshooting an anomaly, much like @gunjanm mentioned. Sometimes I use DataDesigner as a workspace/sandbox of sorts and really don’t intend to make a permanent dataset. I find the Explore section tedious because you have to re-add all the fields you want to see. Much like the preview pane in the initial setup of the design, I’d like to just see all of the data appear at once instead of having to click around further. This is the expected behavior with an export to Excel or Google Sheets. All of the data available immediately in a versatile way.

@All, this is planned for next releases. 

Any update on this? Went down the path of making a DD for a one-time report, not realizing I couldn’t export it. It would have saved time to just create this in the rules engine to export.