Post Author: LaurieBorn
CA Forum: Data Integration
I am trying to link three files in Crystal. For every record in the primary file there may be several records in the other two files. I want all of the matching records in the second file, but only want to use the third file for a formula If statement. I did a left outer join to the primary and I did a left outer join from the second to the third file. With my current join I am getting duplicate fields from the second file based on the matching records in the third file. How can I access a record from the Third file to use in my formula without having an impact on how the records are printed from the other files?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.