Alteryx Designer Desktop Discussions

ricoo · ‎09-07-2023

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.

flying008 · ‎09-07-2023

Hi, @ricoo

FYI.

录制_2023_09_08_12_10_57_316.gif

ricoo · ‎09-07-2023

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.

flying008 · ‎09-07-2023

If can help you get your want, please mark it as a solution and give a like for more share.

ricoo · ‎09-07-2023

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?

flying008 · ‎09-08-2023

1 is true, then the formula action can be enable.

ricoo · ‎09-10-2023

Right. Thanks!

lhanson2 · ‎01-22-2024

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