Kristi Carter Posted May 18, 2021 Posted May 18, 2021 I am looking for hopefully an easily solution within the Info Assist and/or Designer option to be able to Transpose Columns to Rows and visa versa. I was thinking at one point I saw in a demo or something that this is an option within Info Assist or App Studio, Designer or something. Is there an option in 8207.27 (as we are upgrading to this soon) What it looks like now: The below is what we would like it to look like in the end. The measures are in Row format and the years are in column format. Thanks, Kristi Carter
Douglas Lee 2 Posted May 18, 2021 Posted May 18, 2021 I think youre referring to the PIVOT option in Designer during the synonym creation process.
Warren Hinchliffe Posted May 19, 2021 Posted May 19, 2021 I think the MacGyver technique will do it, but its not point and click simple. Can be done in IA, but as for Designer, more difficult, unless you edit the generated code. Hoping someone else has a better idea
Kristi Carter Posted May 19, 2021 Author Posted May 19, 2021 Yeah I did find that option, but I was hoping in Designer or Info Assist. I will explore the PIVOT option as well however.
Kristi Carter Posted May 19, 2021 Author Posted May 19, 2021 Any chance you could provide a sample to apply in IA
Todd Wallace Posted May 19, 2021 Posted May 19, 2021 This is just an across sort on an uploaded Excel document right You can hold the file and run an across on it. Across in IA.png1090991 133 KB
Kristi Carter Posted May 19, 2021 Author Posted May 19, 2021 Across is not really what we are looking for here. In your example- Country across the top is fine, however the Row would be listed as Sales, Retail Amount, etc not the car listing. If we use the Across it would then put the Sales, Retail Amount, etc., across the top for every Country, which is not what we are looking for. Hopefully I am explaining that right
Todd Wallace Posted May 19, 2021 Posted May 19, 2021 Ok thats harder. I can do it in App Studio not in IA. Use the command Over at the end of your values and it puts the rows over one another. Across with over in App studio.png980793 53.9 KB
Warren Hinchliffe Posted May 19, 2021 Posted May 19, 2021 If the over doesnt work, let me know and Ill build and IA example. Its a bit involved. Requires DEFINES, JOINS. Also format need to be taken into account as well (from what I can see from your example)
Kristi Carter Posted June 1, 2021 Author Posted June 1, 2021 This looks like it is going to work. It would be great to have it all done in the GUI, but at least I can still develop what I need using Info Assist Text Editor. Thanks all for the help.
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