4 Replies Latest reply: Dec 8, 2017 6:12 AM by Andres Prado RSS

    What is best method to reload data  every month?

    Layla Mar

      There are several dashboards in Production.

       

      The only data source is one Excel spreadsheet stored on a folder file path.

       

      Each month the spreadsheet is updated with newly incoming data.

       

      What would be the best method to upload WITHOUT any scripting. No  incremental loads,  no where exists function or use of QVDs.

       

      Can 'Where Exists' be used on an attached csv, file in  QS library ?

       

      What should happen to last month's attached file ? delete every month after new monthly data gets attached ?

       

      Should a new auto generated script be inserted every month ?