2 Replies Latest reply: Feb 25, 2013 10:15 PM by Bill Ringer Salalima RSS

    How to tag records through Qlikview scripting?

      Hi,

       

      Good day!

       

      I have this instances, in one item kit number, it composes of 3 or more item number or items. What I want is to tag them that 3 of them are mother SKU and the rest are free. See example below:

       

      IN THE TABLES BELOW, SAY THAT IT IS ALREADY SORTED PER KIT NUMBER PER ITEM NUMBER... What I want is to tag them per KIT NUMBER, that first TWO ITEMS are MOTHER, and the rest of the items are FREE. How to do the tagging through Qlikview scripting?

       

      ITEM KIT NUMBERITEM NUMBER
      KIT001ITEM001
      KIT001ITEM002
      KIT001ITEM003
      KIT001ITEM004
      KIT001ITEM005
      KIT002ITEM001
      KIT002ITEM002
      KIT002ITEM003
      KIT002ITEM004
      KIT003ITEM003
      KIT003ITEM004
      KIT003ITEM005

       

       

      AS RESULT. BELOW SHOULD BE THE FINAL RESULT OF THE TAG.

       

      ITEM KIT NUMBERITEM NUMBERTAG
      KIT001ITEM001MOTHER
      KIT001ITEM002MOTHER
      KIT001ITEM003FREE
      KIT001ITEM004FREE
      KIT001ITEM005FREE
      KIT002ITEM001MOTHER
      KIT002ITEM002MOTHER
      KIT002ITEM003FREE
      KIT002ITEM004FREE
      KIT003ITEM003MOTHER
      KIT003ITEM004MOTHER
      KIT003ITEM005FREE

       

      I hope anyone can help me with this. I need this as client per request. Thanks in advance.

       

       

      Regards,

      Bill Ringer A. Salalima