I am simply trying to merge multiple strings into one array, but only if the column contains a value. So: "string1"and null would turn into ["string"] and not ["string", null]. Nest is not available in conditional functions(?)

[APrasad_Tri]

Hi @Ben Pawlik? , thank you for your question!

First we are merging the required columns. with "," separator.

Then we use Extract Matches to Array from the toolbar

For Pattern matching elements in the list, use `{![\,]}+` as the pattern. This particular pattern suggests that pick any sequence of characters or symbols except a comma.

`{![\,]}+`

[\,] means look for comma in the row value. "!" negate value in front of the [\,] means exclude comma. {}+ means one or more occurrences.

Please follow the above steps and let us know if you are still having any issues.

Best,

Apeksha Prasad

[bpawlik]

@Apeksha Prasad? Thank you, that is very helpful. I was doing the same thing with extra steps.