How to Push the if statement to Script

[#1]

I have a expression like below: 

COUNT

(DISTINCT(IF([Department Account Opened Date]>=$(vLastMonthstart)
AND [Department Account Opened Date]<=$(vLastMonthend) AND [Post Transaction Credit Amount]>=25,[Department Account Id])))

I would like to do this in script instead of Expression, Can you please point me in right direction

Thank you,

[manas_bn]

Let vLastMonthstart = .... //Whatever you need.

Load *,

IF([Department Account Opened Date]>=$(vLastMonthstart)
AND [Department Account Opened Date]<=$(vLastMonthend) AND [Post Transaction Credit Amount]>=25, 1,0) as Dept_Acnt_Flag

Resident Your_Table;

In the front end, Count({$<Dept_Acnt_Flag={1}>} distinct [Department Account Id])

[#3]

HI,

Try this

Check:

LOAD Count(DISTINCT Department Account Id) AS Countval;

Load

IF([Department Account Opened Date]>=$(vLastMonthstart)
AND [Department Account Opened Date]<=$(vLastMonthend) AND [Post Transaction Credit Amount]>=25,  Department Account Id) AS Department Account Id

Resident your label name;

[#4]

Hi,

You can also try like this

Check:

LOAD Count(DISTINCT Department Account Id) AS Countval;

Load

Department Account Id)

Resident your label name

Where

[Department Account Opened Date]>=$(vLastMonthstart)
AND [Department Account Opened Date]<=$(vLastMonthend) AND [Post Transaction Credit Amount]>=25

[rajeshvaswani77]

You have to load preceding load.

T1:

Load *, if statement;

Load

field1,

field2,

..

from tablename

Thanks,

Rajesh Vaswani

[#6]

Thanks everybody, It works