topic Re: Create Custom Field During LOAD in QlikView

Create Custom Field During LOAD

Thu, 17 Jul 2014 23:11:59 GMT

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

(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?

Re: Create Custom Field During LOAD

jer_2011 — Thu, 17 Jul 2014 23:46:43 GMT

Hello,

you can try with this option

LOAD Account,

Product,

Division,

Amount,

If( Amount >= 0.01, 'Yes' , 'No' ) as Special

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

hope it works

Re: Create Custom Field During LOAD

Thu, 17 Jul 2014 23:53:20 GMT

Thanks! Worked like a charm!