I have the following two extracts I want to use in QV:
Application extract - has application number only
Account Extract - has application number AND account number.
I need to create an account number field in the Application Extract as well.
So, if person A is [Application No] 123 in the application extract, I need it to match it to the [Application No] in the account extract. Then create a new field in the application extract called [Account No], and it must get this account number from the account extract. Does this makes sense?
If not, read the rest please, but this might confuse even more:
I have 3 extracts I am using:
Application Extract - this has an application number
Account Extract - this has the application number AND an account number
Transaction extract - this has only the account number
I need to determine (from the transaction extract) how many of the new accounts made a purchase in each month. The problem is that the transaction and the application extract do not have common fields.
So, what I need to do (I think) is load all 3 extracts, then add a new field to the application extract which CREATES the person's account number, so I can match it to the account numbers in the transaction extract.
So, example for Person A:
In application extract - application number 123
In account extract - application number 123, account number 345
Transaction account - purchase by account number 345
I need the application extract to have a new field with account number 345 so I can match my applications to my transactions.
It loads fine now, but for some reason it gets 1024 Account Numbers - there should only be 1017.
Any idea why this is happening? I have NO experience with QV or anything resembling scripts, so please excuse my stupidity. If you can fix it, please send me the script in a text file (I have QV personal edition so won't be able to open a QV file).
Is there any way I can add the person's account number to the Application Extract, by matching the [Appl No] of the application and account extracts.
Because I need to determine how many people mad a purchase in the same month as they were approved, and if I have no account number in my application extract I don't know how to do this.
Please look at the second sheet of my file - I REALLY need help with this, I either have to add an account number to the application extract, or I need to add an application number to the transaction extracts.
Also, I will have to add transaction and application extracts for the last year (one per month) and I'm not sure how to do this, I don't know when to concatenate and when to join