Define a new field while loading data in QV using if statement

[hossein61]

Hi

In my DB, I have "Price", "Flag1" and "Flag2" fields. I want to create a new field "Price2" while loading data in QV which contains Prices that meet following criterias:

Flag1>3 and Flag2=1.

In other words for a record: if Flag1>3 and Flag2=1, Price2 should be same as Price. Else, Price2 should be '0'.

How could I do this?

Hossein

[Mark_Little]

HI ,

In you load script add a new line

IF( Flag1 > 3 and Flag2=1, Price,0) as Price2

Depend where you add the line you may need a comma at the end

[MendyS]

Hi @hossein61

used load inside load,

try this -

Table1:

*, if (Flag1>3 and Flag2=1), Price,0) as price2 ;

load .... from DB...;