Here is the situation:
I have exported the following tables from RE:
CnBio CnGf_1 CnGf_1_Attr_Cat1 CnGf_1_Attr_Cat2
Joe 20 4 1
Steve 10 1 5
Kate 30 6 3
The sitatuon is that Joe only bought 4 adult tickets (did not have data in CnGf_1_Attr_Cat2), so Crystal XI pulled Steve's adult ticket purchase (CnGf_1_Attr_Cat1) into the "child ticket" field (CnGf_1_Attr_Cat2)
I have played around with several join options, but can't get it to look like it should which is:
Joe 20 4
Steve 10 1 1
Kate 30 6
Thanks for your help. I need to find a good/affordable on-line training for stuff like this. Any suggestions?
Bryce
Bryce, if the gift attibute categories are named differently (for example, Child Tickets and Adult Tickets) and the gift attribute descriptions are the numbers, then you should export each gift attribute seperately. However, if they are both under the same gift attribute category - my first question would be: how do you know which one is the Child Ticket and which one is the Adult Ticket?
If the gift attribute category is the same, but the gift attribute description has multiple table entries, then you should upgrade to the latest version of Raisers Edge (if you have not done so already). One of the new features of RE 7.91 is the ability to specify which gift attribute description (as long as it is a table) you want to export.
In Raisers Edge, how are you exporting the data? Export type, fields, export format, etc.
Patrick,
Thanks so much for looking into this for me.
I am exporting a gift attribute, the descriptions are different Ticket (adult) Ticket (children) and are not in a table. I know which is which by the order that they are exported. We are updated to the newest version of RE (but of course it is not a table).
I am doing a a constituent export to mdb the fields are:
Sorry I realized that you could'nt see all the fields