Concatenate All Fields Dynamically
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All,
Is there a way in Alteryx where in I could dynamically concatenate all columns from a data set? I’m thinking of using Multi-Field Formula, but I don’t know how I could apply it. I needed it to be dynamic so that it can accept different data structure from different data sets. If I could make it work, I'm thinking of using it inside a macro.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @flying008 Thanks for this. I'm gonna try this one. I haven't tried yet this rightmost tool in grey yet. I'll respond on the results that I would get.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If can help you get your want, please mark it as a solution and give a like for more share.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @flying008 it worked! Thank you so much. This is my first time to use the Dynamic Replace tool though so I have to figure out how to use this. And I had to discover this myself to tick the checkbox "Values are Expressions/Formulas" in order to get the actual values concatenated.
Also, I wonder why do we have to set the Bool column hardcoded to be "1"? I just copied your method but I didn't exactly know the reason why?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
1 is true, then the formula action can be enable.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Right. Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @flying008 ,
I am reaching out for similar assistance with concatenating fields dynamically. I saw the solution; however, I don't understand how to configure the tools. Here's an example of my output.
id | filter | classification | vin | optid.1 | optid.2 | optid.3 | optid.4 | optid.5 | optid.6 |
1 | valid | passenger | 125487963 | 908521 | 147896 | 758987 | 758986 | 758982 | 758985 |
2 | valid | passenger | 125478936 | 808521 | 708521 | 608521 | 508521 | 408521 | 108521 |
I would like to know how to concatenate the columns containing "optid" dynamically because they vary. Any help that you can provide will be greatly appreciated.
Thank you, Lisa Hanson
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @flying008 ,
This is great! Thank you very much for the help. Can you please share the Dynamic Replacement tool's configuration?
