7 Replies Latest reply: May 9, 2016 8:17 AM by Gysbert Wassenaar RSS

    how to load multiple weekly files in script

    Yogita Mehta

      HI Everyone,

       

       

      i have a doubt related to file structure.

       

      I have a excel file  i'm loading data from that file that file name has date embed in this .Book_22042016 , So i'm getting this file on weekly basis , like next file would be 29/04/2016 .

       

       

      Every file has same type of data like in file we have item number ,  total 100 item number are there , these are fixed , no addition in that just the status of items are changing  So my dashbaord should show the current week data  and in another graph i will show last week and current week Progrees in status means i want to count stattus that is the progress.

       

      how should i write my script so that it will capture all the weekly files and if i want i can show last week and current week data.