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
