Excel TEXTJOIN function

Feature requests
1

Excel a while back added a new function TEXTJOIN which is sort of an enhanced concatenate function. Any chance of getting a similar function added to EasyMorph? A good use example would be creating, say, a keyword column from values in other columns that need to be separated by a delimiter. Yes, this can be done using [Col1] & “, “ & [Col2] & “, “ & [Col3]. But if [Col2] is empty, this results in extra unwanted delimiters:

Col1, , Col3

TEXTJOIN handles this situation effortlessly.

Thanks for considering.

2

Hi Frank,

You can use the “Unpivot” and “Concatenate text” actions. That combination handles missing values correctly. See the example below:

concat.morph (3.4 KB)

image
image942×471 8.82 KB

1 Like
3

Thanks for that solution. I should have mentioned that I already have a work-around that I use, but it’s frustratingly cumbersome. I find TEXTJOIN to be such a simple and elegant solution in Excel– in EasyMorph it would require just one action with a simple formula– that I was hoping you may be interested in adding a similar function to EasyMorph.

4

You have a point! We will consider adding a similar function in EasyMorph.

5

Wonderful… thanks Dmitry!