Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 NUMBER | ITEM NUMBER |
---|---|
KIT001 | ITEM001 |
KIT001 | ITEM002 |
KIT001 | ITEM003 |
KIT001 | ITEM004 |
KIT001 | ITEM005 |
KIT002 | ITEM001 |
KIT002 | ITEM002 |
KIT002 | ITEM003 |
KIT002 | ITEM004 |
KIT003 | ITEM003 |
KIT003 | ITEM004 |
KIT003 | ITEM005 |
AS RESULT. BELOW SHOULD BE THE FINAL RESULT OF THE TAG.
ITEM KIT NUMBER | ITEM NUMBER | TAG |
---|---|---|
KIT001 | ITEM001 | MOTHER |
KIT001 | ITEM002 | MOTHER |
KIT001 | ITEM003 | FREE |
KIT001 | ITEM004 | FREE |
KIT001 | ITEM005 | FREE |
KIT002 | ITEM001 | MOTHER |
KIT002 | ITEM002 | MOTHER |
KIT002 | ITEM003 | FREE |
KIT002 | ITEM004 | FREE |
KIT003 | ITEM003 | MOTHER |
KIT003 | ITEM004 | MOTHER |
KIT003 | ITEM005 | FREE |
I hope anyone can help me with this. I need this as client per request. Thanks in advance.
Regards,
Bill Ringer A. Salalima
One way of achieving the result is in the attached solution. Hope this helps.
One way of achieving the result is in the attached solution. Hope this helps.
Hi Kris,
Wow! This is great.
Thanks for the help.
Regards,
Bill