Challenge #151: Meta Parsing
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
JoeS
Alteryx Alumni (Retired)
02-05-2019
05:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
KevinW
8 - Asteroid
02-05-2019
06:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
itestu
Alteryx
02-05-2019
06:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
danilang
19 - Altair
02-05-2019
07:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
PadmajaS
7 - Meteor
02-05-2019
08:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Number4
8 - Asteroid
02-05-2019
10:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
cgoodman3
14 - Magnetar
02-05-2019
11:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Too many tools compared to other solutions posted.
Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
cgoodman3
14 - Magnetar
02-05-2019
11:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Too many tools compared to other solutions posted.
Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
358802
5 - Atom
02-05-2019
12:45 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
AndrewSharot
5 - Atom
02-05-2019
01:19 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator