2 Replies Latest reply: May 22, 2012 5:29 AM by Roberto Angelucci RSS

    Skipping Lines when loading data

      Is there a way to skip particular lines when loading data? Eg. I have an excel file that is generated on a daily basis. However one of the fields has both numeric data and not. I am interested in Qlikview to load only the numeric ones. So programmatically I would check if the field is numeric, if false I would skip to next line. But I don't know how to do this in Qlikview. Any help would be much appreciated.

       

      regards,

       

      Roberto