change data source from excel file to database view

[Iheb_Ghali]

hello everyone!!

i have an Excel file (containing data extracted from a view ) used as a data source to develop some reports, now i have to change the data source from the Excel file to that database view, is there any solution to do it without redoing the entire work?   

thanks 

[blopez11 · Accepted solution]

I haven't tried it, but you could bring in your data with the view

Then in the query editor, try to replicate the transformations you've done to the excel file using the Advanced Editor

[Iheb_Ghali]

that worked just fine!!

thank you very much