This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi,
I have an app that lets a user select a list of columns from the data, which will be shown as output.
Suppose there is 10 columns and user selects 3 (A,B,C) from them. Is it possible to create a formula which will concatenate the 3 fields as ABC?
In case someone selects A,B,C and D, the concatenation field should have ABCD values. All fields are strings.
In short-How can i create a concatenation field that will dynamically concatenate the user selected fields?
Thanks,
Bharath
Solved! Go to Solution.
I've created a simple macro that will do this inline; hopefully it should be straigthforward for you to pursue the same concept in your Analytic App. Basically, I have a List Box of checkboxes attached to the Macro Input, which generates a custom list of ToString([f1])+ToString([f2]) for whatever fields are checked. My action then replaces the expression in a Formula Tool with exactly that custom list.
Hope that helps!
Thank you guys for taking a shot at the challenge. JojnJPS and jpdunkerly79. Really appreciate it 🙂
I was able to implement it using dunkerley's solution!
PERFECT!