Question on DataMart

[yk98]

I'm using Dataflows as a source for my datamart. Is there a way to create a new table using the view that gets generated as a result of an SQL query? For example- I'm merging two tables using an SQL query inside my datamart, is it possible to store this new merged table as a table in my datamart?

If not, what could be a possible solution to this? I could only think of converting the SQL code to M code and creating a new table, or using a dataflow to create the table I want and use it in the datamart directly as a source.

Thanks in advance! 🙂

[Anonymous]

Hi @yk98 

You mean you want to create a new table by an SQL query in datamart , then you can use the new table as a data source to create other content , right ?

Best Regards,
Community Support Team _ Ailsa Tao

[yk98]

Hi @Anonymous ,

Yes, thats correct.