Skip to Content
0
Former Member
Feb 12, 2009 at 02:27 PM

Script Logic - Filter

82 Views

Hi All,

i want to create a set of all ACCOUNT's of a particular ENTITY.

For example,

When am uploading transaction data as below,

ACCOUNT,ENTITY,DATASRC,INTCO,RPTCURRENCY,TIME,CATEGORY,AMOUNT

570927,32000,INPUT,NON_INTERCO,LC,2008.JAN,ACTUAL,1000

570930,32000,INPUT,NON_INTERCO,LC,2008.JAN,ACTUAL,2000

570999,32000,INPUT,NON_INTERCO,LC,2008.JAN,ACTUAL,3000

600100,42000,INPUT,NON_INTERCO,LC,2008.JAN,ACTUAL,5000

600200,42000,INPUT,NON_INTERCO,LC,2008.JAN,ACTUAL,6000

i want all the ACCOUNT(570927,570930,570999) numbers of ONE ENTITY=32000 in a variable

to use in Script Logic.

Can any one of you please explain how can i achieve this.

Thanks in advance.

Regards,

Sai