topic Re: Define a new field while loading data in QV using if statement in App Development

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

hossein61 — Thu, 01 Dec 2022 07:05:43 GMT

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

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

Mark_Little — Thu, 01 Dec 2022 07:37:05 GMT

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

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

MendyS — Thu, 01 Dec 2022 07:38:15 GMT

Hi @hossein61

used load inside load,

try this -

Table1:

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

load .... from DB...;