Concat Function

[Karthick30]

Hi,

 I have a Dataset like below. I am creating one new column by using Concat function. its for combination of code column.

New Column : aggr(Concat(Code, ','),Plant)

I am getting correct Output. But for A113. I am having blank in input. so output coming as ,LXGH. Is there any way to remove , (comma) in the string.

[edwin · Accepted solution]

try this in your table, its looking only for code len > 0

[edwin]

is one shows what it looks like the way you did it without the set analysis  phrase

[sidhiq91 · Accepted solution]

@Karthick30 Could you please try the below expression. I will attach the output as well.

=if(left(Aggr(Concat(Code,','),Plant),1)=',',mid(Aggr(Concat(Code,','),Plant),2,Len(Aggr(Concat(Code,','),Plant))),
Aggr(Concat(Code,','),Plant))

If this resolves your issue, please like and accept it as a solution.