5 Replies Latest reply: Feb 23, 2015 9:19 PM by Antonio Caria RSS

    Double 'if' condition in load script?

      Hi,

       

      I was wondering if you could help me.

       

      I have a large dataset from which I would like to load into my QV only observations for which EITHER of the following two fields equals to 10: Home_location or Work_location.

       

      While I've thought of other ways to extract only the data needed, I'm wondering whether it's possible to use a condition in the load script to load only data where either Home_location=10 or Work_location=10. I need to keep both these fields in the data.

       

      I would greatly appreciate any suggestions. I've attached a sample data, actual dataset is much bigger.

       

      Many thanks in advance,

       

      Marketa