Search results

Hello, I'm trying to do the following task: Input files --> csv file 1 with 360 columns of cashflow --> csv file 2 with corresponding rates for the 360 columns Task --> calculate present value based on the cashflow and rate file (i.e. file 1 column 1 * file 2 column 2 + file 1 column 2 *...

I'm trying to add a column called "RecordID" to my table based on the unique field "AccountNum". The "RecordID" would be a sequential number starting from 1. Hopefully this can be done in a query. i.e. original table: AccountNum 242 256 298 308 output table: RecordID AccountNum 1...