TextJoin in Appsheet

Jpaulsen · 03-13-2022 07:24 PM

Just wondering what the work around is for this excel formula

"" =TEXTJOIN(", ",TRUE,UNIQUE(IF(Z2=$C$2:$W$75,$B$2:$B$75,""))) ""

Z2 = Value to look for

$C$2:$W$75 = Size of area to look in

$B$2:$B$75 = Values that is associated to the look up value

Work great in Excel, I can do wide searches with it, but AppSheet doesn't like the formula when it's in worksheet.

Thank you in advance.

Aurelien

You may want to combine CONCATENATE(), UNIQUE() and SELECT() expression together, and use it in a new virtual column.

It will be something like that:

CONCATENATE(
  UNIQUE(
    SELECT(YourTable[YourColumn],
      yourMatchConditionThatReturnsTrueOrFalse
    )
  )-LIST("")
)

For reference: