0 Replies Latest reply on Feb 16, 2016 12:34 PM by Slappyboy

    Creating a script to export a report to a new table

    Slappyboy

      Hi everyone,

       

      This is my first post so If I missed anything or posted in the wrong section, apologies in advance.

       

      I created a headcount file which will be used to determine how many agent do we have in different departments.

       

      The file is importing records with different fields and I currently have a report layout that gives me an overview of all the departments / sites...etc.

       

      The issue I'm facing is that every week, I'll be given a new file (to import records) and I will need to include week on week progression for the departments. For example, +4 in department 1, -2 in department 2 etc....

       

      While I could export to excel the report, import it again in a table called current week and have another table with the previous weeks data, I could work out some calculations.

       

      The question is: Is there a way to create a script to get the data from the report layout and put them in a specific table? Is there also a way to move the data from the current week (report already exported)  to a new table created by a script so that I could easily have historical data to work with?

       

      I hope I am clear enough. Anyway, if anyone sees this post and have an answer, whether it is possible or not, I would really appreciate any reply.

       

      Thank you !