Is this something QlikView can’t do? Skip missing fields
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.
Find OptionA, OptionB, OptionC, OptionD,OptionE, OptionF , or OptionG and call it OptionH