Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Perfect use case for the Crew Macro - Dynamic Formula.
A lot more efficient than other ways, especially if we were to be playing with more than 100 rows of data.
Also keeps the field order as well.
Take a look into the macro - it's modifying the XML, kudos to @AdamR_AYX in creating this years back!
Nice challenge. Tricky getting the output column order correct.
Spoiler
I went the transpose-join route as opposed to using an append fields/formula combo
I got the column order correct by using the Data dictionary record ID as the key in the Cross tab. These get sorted into the proper order then it's a dynamic rename
I got the column order correct by using the Data dictionary record ID as the key in the Cross tab. These get sorted into the proper order then it's a dynamic rename
Dan
