Forum Discussion

Iheb_Ghali's avatar
Iheb_Ghali
Frequent Visitor
9 years ago
Solved

change data source from excel file to database view

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? :smileysad:  

 

thanks 

Need Help
  • blopez11's avatar
    blopez11
    9 years ago

    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

2 Replies

  • blopez11's avatar
    blopez11
    Super User
    9 years ago

    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's avatar
      Iheb_Ghali
      Frequent Visitor
      9 years ago

      that worked just fine!!

       

      thank you very much :smileyhappy: