3 Replies Latest reply: Jul 31, 2014 9:16 AM by Josh Abbott RSS

    Beginner struggling with scripting

      Hi everyone,

       

      First post here and new to the scripting of Qlik

       

      I've got a slight issue with a table I'm loading. Due to the format of the data, it comes out something like this (the main column i'm having issue with, the rest of the data is in the correct format):

       

      Workcenter/Resource(Customised)
      BR
      BR
      BR
      BR
      BR
      BR
      SOUTH WEST
      SOUTH WEST
      SOUTH WEST
      SOUTH WEST
      SOUTH WEST
      SOUTH WEST
      WILLIAM FROST
      WILLIAM FROST
      WILLIAM FROST
      WILLIAM FROST
      WILLIAM FROST
      WILLIAM FROST
      CARL HEWLETT
      CARL HEWLETT
      CARL HEWLETT
      CARL HEWLETT
      CARL HEWLETT
      CARL HEWLETT
      WW01/4997225
      WW01/4997225

       

      What I need to do is have it set up like

       

      Cost
        Centre
      FLMPerformance
        Manager
      S241Erick MuriithiWilliam Frost
      S242David R JonesWilliam Frost
      S243David B SmithWilliam Frost
      S244Carl HewlettWilliam Frost
      S245Paul GarlandWilliam Frost

       

      As you can see, Carl Hewlett is a FLM to the PM William Frost

       

      I have that table as a lookup table in my script already

       

      Basically, is there a way to link that one column to that Lookup table?

       

      If I'm not making much sense I do apologise

       

      Look forward

       

      Ant