Combine unique values only

[Anku]

Hi all,

Please refer to the snanpshot and advice how to combine unique values only.

[Nagaraju_KCS · Accepted solution]

Hope this helps!

LOAD *, Column1&
IF(Column1=Column2, '', ','&Column2)&
IF(Column1=Column3 or Column2=Column3, '', ','&Column3) &
IF(Column1=Column4 or Column2=Column4 or Column3=Column4, '', ','&Column4) as OutPut;