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:
(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".