10 Replies Latest reply: Sep 24, 2014 6:40 AM by Kasia Cwik RSS

    How to split one record into many using SubField?

    Kasia Cwik

      hi

       

      I have sample date from a client, it comes in a very strange format, one line:

       

      COR032532917ý17ý991701ý1706ý990225191ý31608ýMISC-TGT1ý1ý14171ý800ý03616ý0ý405IN14754NIM1NIMEMASCO8379ý8379ý8240083ýý

       

      when pasted into word the records are split:

       

      COR
      032
      5329
      17ý17ý99
      1701ý1706ý9902
      25191ý31608ýMISC-TGT
      1ý1ý1
      4171ý800ý0
      3616ý0ý405
      IN
      14754
      NIM1
      NIMEMA
      SCO
      8379ý8379ý8240

      083
      ýý

       

      Lines 4-9 and 15 have 3 records per line, I want to load this into Qlikview and as a result have 3 lines. I'm using the SubField but I'm ending up with every possible variation - 407 lines... I attach my qvw, I would gladly appreciate some help

       

      Thank you

       

      Kasia