2 Replies Latest reply: Jul 24, 2015 5:34 AM by Jemimah Bag RSS

    QVD from Text File

      Hi,

       

      I have text files for various dates saved in a folder.

       

       

      Needed to create a QVD with below conditions.

       

       

      1) Below header need to be added to the data in the txt files.

       

       

      Date Interval ID Code Status Handled Closed

       

       

      2) date needs to be picked from file name assuming the file name will be saved based on date format (YYYY-MM-DD)

       

       

      3) First two column in txt will have some blank rows which needs to be updated based on previous row data.

       

       

       

       

      attaching sample text file