9 Replies Latest reply: Jan 13, 2017 2:25 PM by Dave Melillo RSS

    Create New Fields using File Name

    Dave Melillo

      I have many csv files I need to load with a standard naming convention ... examples are:






      I would like to load all fields and created two more fields


      PERIOD = first 5 characters of file name (i.e 200704)


      SUBJECT = characters after hyphen ( - ) (i.e jenkins)


      I also need to turn the PERIOD into a date that can be used by Qlikview for time series analysis.


      Any help is appreciated.


      Thank you,


      - dave