Flags

[rathnam_qv]

Hi All

i have nearly 1300 Accounts ...

i want to create 1 flag for 21 Accounts...and another flag for remaining Accounts..

So, How to create That Flags...

Can any one help me

Thanks in Advance!!!

Smiley

[rajeshvaswani77]

Create a column using if condition, if the conditin is true you have one value( for 21 accounts) and in else you will have another value. Call this new column name as flag or any appropriate name.

thanks,

Rajesh Vaswani

[rathnam_qv]

Hi,

can u please send me the script

[MayilVahanan]

Hi

try like this

If(Accounts <= 21, 1, 0) as Flag

or

If its not in order, then try with match() function , like

if(match(Account,1,2,34,5,67,889,45,46), 1, 0) as Flag

hope that helps

[rathnam_qv]

Hi,

i know the 21 account numbers...remaining i don't know...

then

[kalyandg]

hi rathnam,

for 21 accounts(which do u know)

try as the above reply by mayilvahanam

for the next 21,

try as

if(Accounts<>21, 1,0) as Flag2

kindly reply

Thanks,

Kalyan

[jagan]

Hi,

Try like this

LOAD

*,

if(match(Account,1,2,3, .....................your 21 account), 1, 0) as Flag,

if(not match(Account,1,2,3, .....................your 21 account), 1, 0) as RemainingAccountsFlag

FROM Datasource;

Regards,

Jagan.

[#8]

try according to this condition

If(Accounts <= 21, 1) as Flag1

If(Accounts > 21, 0) as Flag2

***************************************

or add rowno() as key

then try

if(key<=21,1) as flag1,

if(key>21,0) as flag2

[CELAMBARASAN]

Hi,

If(Match(Accountnumbers, 1,2,3,4,5....,21), 1, 0) AS Flag

Here Flag =1 has account numbers you know. Flag =0 has remaining account numbers