5 Replies Latest reply: Aug 21, 2014 9:29 PM by jagan mohan rao appala RSS

    Is this something QlikView can’t do? Skip missing fields

    Dan McDonald

      Based on countless hours of looking and replies to similar posts, I am guessing that you cannot skip a field in a load statement if the field does not exist. I am trying to load 1 field from multiple files that may have up to 7 different names but they all mean the same thing. The field is not always in the same column on each file. I am looking to simply skip the field if the name does not exist.
      1 name will exist but only 1 of the 7 so I want to call all 7 fields but skip if the field is not listed.

       

       

      Example:

       

       

                  Find OptionA, OptionB, OptionC, OptionD,OptionE, OptionF , or OptionG and call it OptionH