I have a table. I like to filter few rows based on a condition and concatenate the values of a column for the selected rows. For example- the filter is returning 5 rows and the values for column1 are AA, BB, CC, DD and EE.
I like to display AA - BB - CC - DD - EE
Can I do this?
Hi @Gout-436f, welcome to the community!
You can iterate writing a value from specific rows with a FILTER formula in the run options. For your example, I filtered out data based on a particular set ("Data Set A") in the run options, and then used FINDROW() to overwrite the string value in another table (called "Strings"). You can play with the CONCATENATE formula to get your desired output:
For another option, if it's only a few rows as you noted, you could instead do a CONCATENATE of the desired cells like this:
Hope that helps! Let us know if you have further questions. Also, could you share more about your exact use case for this? That's helpful for our team as we continue developing Honeycode.