data fprmat problem

[#1]

Dear Community,

I have field like this i need to convert into year format

based on that year i need to show comparative analysis

in that filed string also is there please advise the solution

2007-08

2008-09

2009-10

2010-11

2011-12

2012-13

Apr-10 to Apr-10

Apr-10 to Aug-10

Apr-10 to Dec-10

Apr-10 to Feb-11

Apr-10 to Jan-11

Apr-10 to Jul-10

Apr-10 to Jun-10

Apr-10 to May-10

Apr-10 to Nov-10

Apr-10 to Oct-10

Apr-10 to Sep-10

Apr-11 to Apr-11

Apr-11 to Aug-11

Apr-11 to Dec-11

Apr-11 to Feb-12

Apr-11 to Jan-12

Apr-11 to Jul-11

Apr-11 to Jun-11

Apr-11 to May-11

Apr-11 to Nov-11

Apr-11 to Oct-11

Apr-11 to Sep-11

Apr-12 to Apr-12

Apr-12 to Aug-12

Apr-12 to Dec-12

Apr-12 to Feb-13

Apr-12 to Jan-13

Apr-12 to Jul-12

Apr-12 to Jun-12

Apr-12 to May-12

Apr-12 to Nov-12

Apr-12 to Oct-12

Apr-12 to Sep-12

Apr-13 to Apr-13

Apr-13 to Jun-13

Apr-13 to May-13

Aug-10 to Jul-11

Aug-11 to Jul-12

Dec-09 to Nov-10

Dec-10 to Nov-11

Dec-11 to Nov-12

Feb-10 to Jan-11

Feb-11 to Jan-12

Feb-12 to Jan-13

Jan-10 to Dec-10

Jan-11 to Dec-11

Jan-12 to Dec-12

Jul-10 to Jun-11

Jul-11 to Jun-12

Jul-12 to Jun-13

Jun-10 to May-11

Jun-11 to May-12

Jun-12 to May-13

Mar-10 to Feb-11

Mar-11 to Feb-12

Mar-12 to Feb-13

May-10 to Apr-11

May-11 to Apr-12

May-12 to Apr-13

Nov-09 to Oct-10

Nov-10 to Oct-11

Nov-11 to Oct-12

Oct-09 to Sep-10

Oct-10 to Sep-11

Oct-11 to Sep-12

Sep-10 to Aug-11

Sep-11 to Aug-12

[#2]

Hi,

I see there are values that are 1 month period and others that are many months.

Does that data come from an Excel spreadsheet? In that case, I recommend you to clean it or make some kind of transformation before loading into QV.

If not, the solution could be a tricky (but not impossible) LOAD statement.