2 Replies Latest reply: Feb 11, 2015 8:02 AM by marc carreras RSS

    derive period from date and column heading

    Hans kleijnen


      I have 2 files. File 1 is actual transactions in csv. File 2 is excel converted in QV to a crosstable.

      File 1 has transaction dates dd-mm-yyyy.

      File 2 has period numbers as column headers: 01, 02,03 etc.

      when creating a pivot table in QV I get columns such as


      Header 1Header 2Header 3Header 4Header 5Header 6Header 7Header 8


      Where 01=jan and 02=feb

      changing headings in excel to jan, feb etc does not solve my problem


      who can help me to solve this issue?


      krgrds Hans


      Het bericht is bewerkt door: Hans kleijnen