Hi there,

I am having an output file resulting from a script, this output file looks as follow:

10 Account1
20 Account2
89 Account3

Now i have another file which includes all the accounts (i.e. all acounts which have records in the mentioned output file and the rest of acoounts which have no records)...what i want to do is the following:

I want to generate a final out put file which have all the accounts and near to each account it mention the total number of recrods resulted from the above output fle, and if there is any account which have no records in the above output file, then in the final output file the value near to that account shall be 0

Any idea how to do that??

Thanks in advance.