James.Rogowski1 Posted January 13, 2022 Share Posted January 13, 2022 I have data where the SQL join is a 1 to many relationship. The report output format looks like the first 2 sections below. My users want to download the report into Excel to do analysis and want all the data for each data record to be in separate columns like my "Desired Output" below. I have tried using crosstab but was not successful. Is there a way to accomplish this? First RecordDataField1DataField2DataField3DataField4DataJoin1tagDataJoin1Field1DataJoin1Field2DataJoin1Field3 DataJoin1tag2DataJoin2Field1DataJoin2Field2DataJoin2Field3 DataJoin1tag3DataJoin3Field1DataJoin3Field2DataJoin3Field3 DataJoin1tag4DataJoin4Field1DataJoin4Field2DataJoin4Field3 Second RecordDataField1DataField2DataField3DataField4DataJoin1tagDataJoin1Field1DataJoin1Field2DataJoin1Field3 DataJoin1tag2DataJoin2Field1DataJoin2Field2DataJoin2Field3 DataJoin1tag3DataJoin3Field1DataJoin3Field2DataJoin3Field3 DataJoin1tag4DataJoin4Field1DataJoin4Field2DataJoin4Field3 Desired Output: First RecordDataField1DataField2DataField3DataField4DataJoin1tagTag1 Field1Tag1 Field2Tag1 Field3Tag2 Field1Tag2 Field2Tag2 Field3Tag3 Field1etc Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now