4 Replies Latest reply: Jun 3, 2016 6:42 AM by Sasidhar Parupudi RSS

    converting fields as subfields

    PROSPEROUS DLAMINI

      Hi I Have table like below...

       

          

      Soccer Teams Leagueperfomence20082009201020112012
      dallasMajorwon1520172219
      dallasMajorlost75734
      sundownsPSLwon112217923
      sundownsPSLlost1079124
      man cityEnglishwon2528312220
      man cityEnglishlost853711
      G RangersScottishwon1517131911
      G RangersScottishlost35216
      Real Madridspainwon3027322433
      Real Madridspainlost354102

       

       

       

      I want to format as below.How can I do that in qlik sense ?

       

         

      Soccer TeamLeagueResultsSeasonPerfomance
      dallasMajorlost20087
      dallasMajorlost20095
      dallasMajorlost20107
      dallasMajorlost20113
      dallasMajorlost20124
      dallasMajorwon200815
      dallasMajorwon200920
      dallasMajorwon201017
      dallasMajorwon201122
      dallasMajorwon201219
      G RangersScottishlost20083
      G RangersScottishlost20095
      G RangersScottishlost20102
      G RangersScottishlost20111
      G RangersScottishlost20126
      G RangersScottishwon200815
      G RangersScottishwon200917
      G RangersScottishwon201013
      G RangersScottishwon201119
      G RangersScottishwon201211
      man cityEnglishlost20088
      man cityEnglishlost20095
      man cityEnglishlost20103
      man cityEnglishlost20117
      man cityEnglishlost201211
      man cityEnglishwon200825
      man cityEnglishwon200928

       

       

      Thanks you