This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
How important is it for you to have the Legal Entity in a separate row above the main report? Alteryx doesn't allow you to have null or multiple headers for the same field.The simplest solution would be to write a formula to combine Legal Entity with LE Desc and place the combined name in the same header.
If it's really necessary to have Legal Entity as the top row, you can use the reporting tools to create a reporting element with just the Legal Entity information, then join that with the separate table in your Layout.
Thanks so much for your response. It is important for me to have the legal entity as the top row, as the output is going to feed another system that requires this specific format. I will give your second option a try and see if I can make it work. I really appreciate your help!
@Jim7 One more question: in the example provided, you use the Select Records tool twice and then union them together. This works, because there are only 2 entities in the sample data provided. However, I have several hundred entities in my real data set and can't do a Select Records tool for each one. Is there another way to pivot the legal entities from one column to rows?
Sure, attached is an example which dynamically reads in whatever number of fields you have. It assumes the first 2 fields in the stream are blank like in your example, but if you anticipate needing more blank fields you can just add them to the Text Input using the same format (!3, !4, etc.). Hope that helps!