Incremental Load using Timestamps Multiple Excel

    Dear All,

    Sharing incremental load using timestamps for Multiple Excels.

     

    Logic of this script :

     

    Step  1.  Will Pull Excels and create qvd ALLQVD.QVD for multiple excel files.

    Step 2.   Will Check whether user is modified excels files if yes then script will mark flag as 1 and

                     delete the records from QVD and append fresh records from modified excels.

     

    Step 3.   Script will check  whether there is new file available for upload if  yes then script will append the same.

     

     

    For developing above script I take help from tresescomayilvahanan , stalwar1 ,pradeept

     

     

    Thanks to all.

     

     

    Vikas