6 Replies Latest reply on Dec 29, 2017 5:47 AM by Zhouyi Zhang

    Concatenation in Tableau


      Please find the attachment and help me to concatenate such type of columns.

      I have tried IIF(ISNULL([TYPE1]),"",[TYPE1]) + IIF(ISNULL([TYPE2]),"",[TYPE2]) + .... + IIF(ISNULL([TYPE6]),"",[TYPE6]) which is concatenating them perfectly but whithout any separator. When I try to put a separator between them it will place the separator in the beginning as well when TYPE1/TYPE2...etc is empty.

      I want the exact concatenated field like the attachment below....

      Please help me out.