2 Replies Latest reply: Jul 17, 2014 7:53 PM by James Kennedy RSS

    Create Custom Field During LOAD

      I'm new to Qlik - so please bear with me as my question is a basic one, but I can't seem to find the right way.
      During LOAD, I have it reading in a CSV file which is perfect. I want to create a new field on the fly based on the data as it loads in. Below is what I have:

       

      LOAD Account,

           Product,

           Division,

           Amount

      FROM

      [C:\test.csv]

      (txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

       

      So my goal is to create a new field called "Special" which populates with "Yes" if Amount is >=0.01, otherwise "No".

      How do I do this?