6 Replies Latest reply: Aug 11, 2016 11:34 AM by Massimo Grossi RSS

    Dynamic assignment in load script

    Keith Curley

      Dear All,

       

      I want to assign a field value in a table during load, based on a value in a previously loaded table, i.e. Check_Table has a list of 20 Orders, Main_Table has all Orders, I want to mark each Order in Main_Table with a flag to identify if it is present in the Check_Table list or not.

       

      could do a join of the two tables but this does not allow me to subsequently select Orders which are not in the Check_Table (as they will have a NULL value in the flag field and not selectable in my dashboard).

       

      Hence, during my load script for Main_Table I want to use something along the lines of:

       

      If [Order] in Check_Table,

           Flag assigned 'Yes'

      Else

           Flag assigned 'No'

       

      Does anyone know how I can do this in Qlikview?

       

      Thanks in advance,

      Keith