0 Replies Latest reply: Sep 30, 2016 1:16 PM by Blaine Hyde RSS

    excel vlookup functionality in Qlik sense

    Blaine Hyde

      Hi.  I have two data elements in a loaded table that if in excel I would have concatenated into a new column in the table and then added an additional column to flag a criteria.

       

      Element 1 = TaskID (multiple records in the table)

      Element 2 = Type (can be multiple values per TaskID)

      Added Element 3 = TaskID&Type

      Desired Element 4 = flag as Y/N if the record has the a matching Element3 in the table with the record's TaskID& a text string Type as  manually selected

       

      Any suggestions on how to create data load editor?  Thanks!