Concatenate All Fields Dynamically

[ricoo]

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.

[ricoo]

Hi @aoxomoxoa , sorry for the late response. This is what's in the formula

[ntajab]

Big thanks this solution was brilliant.